Is it possible to connect EM to a remote server that is not on a LAN or WAN?
Thanks.
Hi
You would need to start EM on the machine itself if there are no network
connections.
John
"Vik" wrote:
> Is it possible to connect EM to a remote server that is not on a LAN or WAN?
> Thanks.
>
>
|||Hi
The previous reply assumed that there isn't a VPN connection! If there is
then you should be able to connect it if the ports correct ports are open on
the firewall. http://support.microsoft.com/kb/287932
You could also try using the web administrator
http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:14E75EEC-6134-43BF-AE4D-56C4D74E28BF@.microsoft.com...[vbcol=seagreen]
> Hi
> You would need to start EM on the machine itself if there are no network
> connections.
> John
> "Vik" wrote:
sqlsql
Showing posts with label lan. Show all posts
Showing posts with label lan. Show all posts
Thursday, March 22, 2012
Connection over internet
I need to connect to a sql server through the internet.
Inside the LAN everything works great, but if try to connect from a pc
outside the lan over the internet I get an error message saying SQLstate
01000 and SQL state 08001 error 17.
What's wrong ?
Thank You since now to anyone can help me
Bye
Paolo
Gian,
How are you addressing the SQL Server? The external IP address should be
different to the one on your LAN. I personally would not be comfortable
with my SQL Server accessible over the internet.
1. Make sure that the correct ports are open on your firewall.
2. Check that SQL Server is listening on TCP/IP, and the port number
3. For named instances set up an alias and "hard code" the port using
the Server Network Utility.
4. Do not allow access through port 1434 on the firewall.
Take a look at this article also:
Potential causes of the "SQL Server does not exist or access denied"
error message
http://support.microsoft.com/?id=328306
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Gian Paolo Piscopo wrote:
> I need to connect to a sql server through the internet.
> Inside the LAN everything works great, but if try to connect from a pc
> outside the lan over the internet I get an error message saying SQLstate
> 01000 and SQL state 08001 error 17.
> What's wrong ?
> Thank You since now to anyone can help me
> Bye
> Paolo
>
|||Hi
There are a few things you'll have to check.
1. Have you got a route from your external PC into the SQL server.? If you
connect via an IP address, you'll have to make sure that this IP address has
a route through your FireWall. If you connect via a name, you'll have to
make sure that this name is bound to the correct IP address.
2. Have you opened the right ports in your FireWall? By default SQL server
uses port 1433, so you need to have a rule in your FireWall that allows this
traffic.
Also, it might help if you tell how you try to connect to the server - with
EM, QA or an application?
Regards
Steen
Gian Paolo Piscopo wrote:
> I need to connect to a sql server through the internet.
> Inside the LAN everything works great, but if try to connect from a pc
> outside the lan over the internet I get an error message saying
> SQLstate 01000 and SQL state 08001 error 17.
> What's wrong ?
> Thank You since now to anyone can help me
> Bye
> Paolo
Inside the LAN everything works great, but if try to connect from a pc
outside the lan over the internet I get an error message saying SQLstate
01000 and SQL state 08001 error 17.
What's wrong ?
Thank You since now to anyone can help me
Bye
Paolo
Gian,
How are you addressing the SQL Server? The external IP address should be
different to the one on your LAN. I personally would not be comfortable
with my SQL Server accessible over the internet.
1. Make sure that the correct ports are open on your firewall.
2. Check that SQL Server is listening on TCP/IP, and the port number
3. For named instances set up an alias and "hard code" the port using
the Server Network Utility.
4. Do not allow access through port 1434 on the firewall.
Take a look at this article also:
Potential causes of the "SQL Server does not exist or access denied"
error message
http://support.microsoft.com/?id=328306
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Gian Paolo Piscopo wrote:
> I need to connect to a sql server through the internet.
> Inside the LAN everything works great, but if try to connect from a pc
> outside the lan over the internet I get an error message saying SQLstate
> 01000 and SQL state 08001 error 17.
> What's wrong ?
> Thank You since now to anyone can help me
> Bye
> Paolo
>
|||Hi
There are a few things you'll have to check.
1. Have you got a route from your external PC into the SQL server.? If you
connect via an IP address, you'll have to make sure that this IP address has
a route through your FireWall. If you connect via a name, you'll have to
make sure that this name is bound to the correct IP address.
2. Have you opened the right ports in your FireWall? By default SQL server
uses port 1433, so you need to have a rule in your FireWall that allows this
traffic.
Also, it might help if you tell how you try to connect to the server - with
EM, QA or an application?
Regards
Steen
Gian Paolo Piscopo wrote:
> I need to connect to a sql server through the internet.
> Inside the LAN everything works great, but if try to connect from a pc
> outside the lan over the internet I get an error message saying
> SQLstate 01000 and SQL state 08001 error 17.
> What's wrong ?
> Thank You since now to anyone can help me
> Bye
> Paolo
Connection over internet
I need to connect to a sql server through the internet.
Inside the LAN everything works great, but if try to connect from a pc
outside the lan over the internet I get an error message saying SQLstate
01000 and SQL state 08001 error 17.
What's wrong '
Thank You since now to anyone can help me
Bye
PaoloGian,
How are you addressing the SQL Server? The external IP address should be
different to the one on your LAN. I personally would not be comfortable
with my SQL Server accessible over the internet.
1. Make sure that the correct ports are open on your firewall.
2. Check that SQL Server is listening on TCP/IP, and the port number
3. For named instances set up an alias and "hard code" the port using
the Server Network Utility.
4. Do not allow access through port 1434 on the firewall.
Take a look at this article also:
Potential causes of the "SQL Server does not exist or access denied"
error message
http://support.microsoft.com/?id=328306
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Gian Paolo Piscopo wrote:
> I need to connect to a sql server through the internet.
> Inside the LAN everything works great, but if try to connect from a pc
> outside the lan over the internet I get an error message saying SQLstate
> 01000 and SQL state 08001 error 17.
> What's wrong '
> Thank You since now to anyone can help me
> Bye
> Paolo
>|||Hi
There are a few things you'll have to check.
1. Have you got a route from your external PC into the SQL server.? If you
connect via an IP address, you'll have to make sure that this IP address has
a route through your FireWall. If you connect via a name, you'll have to
make sure that this name is bound to the correct IP address.
2. Have you opened the right ports in your FireWall? By default SQL server
uses port 1433, so you need to have a rule in your FireWall that allows this
traffic.
Also, it might help if you tell how you try to connect to the server - with
EM, QA or an application?
Regards
Steen
Gian Paolo Piscopo wrote:
> I need to connect to a sql server through the internet.
> Inside the LAN everything works great, but if try to connect from a pc
> outside the lan over the internet I get an error message saying
> SQLstate 01000 and SQL state 08001 error 17.
> What's wrong '
> Thank You since now to anyone can help me
> Bye
> Paolo
Inside the LAN everything works great, but if try to connect from a pc
outside the lan over the internet I get an error message saying SQLstate
01000 and SQL state 08001 error 17.
What's wrong '
Thank You since now to anyone can help me
Bye
PaoloGian,
How are you addressing the SQL Server? The external IP address should be
different to the one on your LAN. I personally would not be comfortable
with my SQL Server accessible over the internet.
1. Make sure that the correct ports are open on your firewall.
2. Check that SQL Server is listening on TCP/IP, and the port number
3. For named instances set up an alias and "hard code" the port using
the Server Network Utility.
4. Do not allow access through port 1434 on the firewall.
Take a look at this article also:
Potential causes of the "SQL Server does not exist or access denied"
error message
http://support.microsoft.com/?id=328306
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Gian Paolo Piscopo wrote:
> I need to connect to a sql server through the internet.
> Inside the LAN everything works great, but if try to connect from a pc
> outside the lan over the internet I get an error message saying SQLstate
> 01000 and SQL state 08001 error 17.
> What's wrong '
> Thank You since now to anyone can help me
> Bye
> Paolo
>|||Hi
There are a few things you'll have to check.
1. Have you got a route from your external PC into the SQL server.? If you
connect via an IP address, you'll have to make sure that this IP address has
a route through your FireWall. If you connect via a name, you'll have to
make sure that this name is bound to the correct IP address.
2. Have you opened the right ports in your FireWall? By default SQL server
uses port 1433, so you need to have a rule in your FireWall that allows this
traffic.
Also, it might help if you tell how you try to connect to the server - with
EM, QA or an application?
Regards
Steen
Gian Paolo Piscopo wrote:
> I need to connect to a sql server through the internet.
> Inside the LAN everything works great, but if try to connect from a pc
> outside the lan over the internet I get an error message saying
> SQLstate 01000 and SQL state 08001 error 17.
> What's wrong '
> Thank You since now to anyone can help me
> Bye
> Paolo
Connection over internet
I need to connect to a sql server through the internet.
Inside the LAN everything works great, but if try to connect from a pc
outside the lan over the internet I get an error message saying SQLstate
01000 and SQL state 08001 error 17.
What's wrong '
Thank You since now to anyone can help me
Bye
PaoloGian,
How are you addressing the SQL Server? The external IP address should be
different to the one on your LAN. I personally would not be comfortable
with my SQL Server accessible over the internet.
1. Make sure that the correct ports are open on your firewall.
2. Check that SQL Server is listening on TCP/IP, and the port number
3. For named instances set up an alias and "hard code" the port using
the Server Network Utility.
4. Do not allow access through port 1434 on the firewall.
Take a look at this article also:
Potential causes of the "SQL Server does not exist or access denied"
error message
http://support.microsoft.com/?id=328306
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Gian Paolo Piscopo wrote:
> I need to connect to a sql server through the internet.
> Inside the LAN everything works great, but if try to connect from a pc
> outside the lan over the internet I get an error message saying SQLstate
> 01000 and SQL state 08001 error 17.
> What's wrong '
> Thank You since now to anyone can help me
> Bye
> Paolo
>|||Hi
There are a few things you'll have to check.
1. Have you got a route from your external PC into the SQL server.? If you
connect via an IP address, you'll have to make sure that this IP address has
a route through your FireWall. If you connect via a name, you'll have to
make sure that this name is bound to the correct IP address.
2. Have you opened the right ports in your FireWall? By default SQL server
uses port 1433, so you need to have a rule in your FireWall that allows this
traffic.
Also, it might help if you tell how you try to connect to the server - with
EM, QA or an application?
Regards
Steen
Gian Paolo Piscopo wrote:
> I need to connect to a sql server through the internet.
> Inside the LAN everything works great, but if try to connect from a pc
> outside the lan over the internet I get an error message saying
> SQLstate 01000 and SQL state 08001 error 17.
> What's wrong '
> Thank You since now to anyone can help me
> Bye
> Paolo
Inside the LAN everything works great, but if try to connect from a pc
outside the lan over the internet I get an error message saying SQLstate
01000 and SQL state 08001 error 17.
What's wrong '
Thank You since now to anyone can help me
Bye
PaoloGian,
How are you addressing the SQL Server? The external IP address should be
different to the one on your LAN. I personally would not be comfortable
with my SQL Server accessible over the internet.
1. Make sure that the correct ports are open on your firewall.
2. Check that SQL Server is listening on TCP/IP, and the port number
3. For named instances set up an alias and "hard code" the port using
the Server Network Utility.
4. Do not allow access through port 1434 on the firewall.
Take a look at this article also:
Potential causes of the "SQL Server does not exist or access denied"
error message
http://support.microsoft.com/?id=328306
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Gian Paolo Piscopo wrote:
> I need to connect to a sql server through the internet.
> Inside the LAN everything works great, but if try to connect from a pc
> outside the lan over the internet I get an error message saying SQLstate
> 01000 and SQL state 08001 error 17.
> What's wrong '
> Thank You since now to anyone can help me
> Bye
> Paolo
>|||Hi
There are a few things you'll have to check.
1. Have you got a route from your external PC into the SQL server.? If you
connect via an IP address, you'll have to make sure that this IP address has
a route through your FireWall. If you connect via a name, you'll have to
make sure that this name is bound to the correct IP address.
2. Have you opened the right ports in your FireWall? By default SQL server
uses port 1433, so you need to have a rule in your FireWall that allows this
traffic.
Also, it might help if you tell how you try to connect to the server - with
EM, QA or an application?
Regards
Steen
Gian Paolo Piscopo wrote:
> I need to connect to a sql server through the internet.
> Inside the LAN everything works great, but if try to connect from a pc
> outside the lan over the internet I get an error message saying
> SQLstate 01000 and SQL state 08001 error 17.
> What's wrong '
> Thank You since now to anyone can help me
> Bye
> Paolo
Connection over Internet
Is it possible to connect EM to a remote server that is not on a LAN or WAN?
Thanks.Hi
You would need to start EM on the machine itself if there are no network
connections.
John
"Vik" wrote:
> Is it possible to connect EM to a remote server that is not on a LAN or WAN?
> Thanks.
>
>|||Hi
The previous reply assumed that there isn't a VPN connection! If there is
then you should be able to connect it if the ports correct ports are open on
the firewall. http://support.microsoft.com/kb/287932
You could also try using the web administrator
http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:14E75EEC-6134-43BF-AE4D-56C4D74E28BF@.microsoft.com...
> Hi
> You would need to start EM on the machine itself if there are no network
> connections.
> John
> "Vik" wrote:
>> Is it possible to connect EM to a remote server that is not on a LAN or
>> WAN?
>> Thanks.
>>
Thanks.Hi
You would need to start EM on the machine itself if there are no network
connections.
John
"Vik" wrote:
> Is it possible to connect EM to a remote server that is not on a LAN or WAN?
> Thanks.
>
>|||Hi
The previous reply assumed that there isn't a VPN connection! If there is
then you should be able to connect it if the ports correct ports are open on
the firewall. http://support.microsoft.com/kb/287932
You could also try using the web administrator
http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:14E75EEC-6134-43BF-AE4D-56C4D74E28BF@.microsoft.com...
> Hi
> You would need to start EM on the machine itself if there are no network
> connections.
> John
> "Vik" wrote:
>> Is it possible to connect EM to a remote server that is not on a LAN or
>> WAN?
>> Thanks.
>>
Sunday, February 12, 2012
Connecting to SQL Server with database on NFS
I tried to connect to SQL server 2005 express in LAN Using C# express
I got this msg
the file \\blablabla\\blablabla.mdf is on a network path is not supported for database file.An Attempt to attach an auto-named database for file \\blablabla\blablabla.mdf failed. a database with same name is exist, or specified file can not be opened, or its located on UNC share.
Is that mean :
I can not connect to SQL server remotly using express edition of C#
SQL server dosen't support connection in LAN
I tried to set all options like enable TCP IP connection and networks
by the way
The data has unquie name and it is located in shared folder and I can easly to connect to database like access with no problem
I will be thankful if you can help me
With the Express Edition of SQL Server you can't connect to databases over LAN. Only local database are supported.|||Firstly Thank you very much to help me..
I read in features of sql express we can make the data in the server and shares the information with others clients. Also because sql express support web devlopment ASP that's mean the databse should be shared in the web ,, All that's mean sql server support to be in local area network !
please be sure, because I think visual C# express dosnt support client server database not sql server !
Im waiting for your comments :-)
|||I am able to connect to an instance of SQL Server Express from seperate machines on the same network using Server Management Studio Express CTP. So it appears access to SQL Server Express does work on a LAN.|||"a database with same name is exist, or specified file can not be opened, or its located on UNC share"
Is one of these three your problem? Is it a file shared on a network? Is the path+filename correct? Does a database with the same name already exists?
Let's rule those out first.
|||I have encountered the same problem attempting to create a .mdf database file on a network drive. The Knowledge Base, Article ID: 304261, states that if you turn Trace flag 1807 on that you can connect to a mapped or UNC network drive. But it doesn't work, as recommended, "http://msdn2.microsoft.com/en-us/library/ms176061.aspx, using the SQL statement "Create Database MyDB ON Primary "S:\blah\blah".It returns the error "Msg 5133, Level 16, State 1, Line 2
Directory lookup for the file "S:\colorlab\stores\_MouerMichael\TestingSQLX\MyLoc.mdf" failed with the operating system error 3(The system cannot find the path specified.)."
If I use the path "C:\blah\blah" - no problem.
Now I know the path is there and the OS finds it OK using other programs.
My goal is to move from a MSAccess DB on a network drive to a SQLExpress DB on a network drive.|||
Experiencing the same issue. I am also wishing to migrate from MSDE.
Using Microsoft SQL Server Management Studio Express I can create and populate a DB.
I wish to connect to it from VB express. However, I receive the error message that was listed in the first post in this thread.
My goal is to have SQL Server host a DB on a small network, allowing several workstations to access it concurrently.
How does one, or can one, share a DB using SQL Server Express?
Thanks in advance,
Lance
|||I have exactly the same problem and still no answer.
Everything can be done using Microsoft SQL Server Management Studio Express
with a local or remote connection, but I can't connect to a database to create a mdf or read, populate (...) an existing database with visual studio c# express.
There is only one way to connect to an SQL server with express studios (c#, VB ...) and it's by selecting an existing mdf file on remote server and it doesn't work at all.
If someone find a solution please post.
Thanks, vax
|||I am having the same problem. I tried setting trace flag 1807 like this:
dbcc traceon (1807,-1)
GO
But the management studio still doesn't seem to like my path (F:\) which is mapped to an NFS share. This is with SQL Server 2005 Enterprise Version.
Thanks
Eno
|||Here is what I have discovered to work.
1) Open the SQL Server Management Studio Express CTP and create a database.
2) Detach the database
3) Exit
4) Go to your language IDE of choice VB, C#, etc.
5) Create a new connection source to the DB you just created.
6) Go to the Solution Explorer and change the property "Copy to Output Directory" to 'Copy if newer'.
7) Close IDE
8) Open the SQL Server Management Studio Express CTP and reattach to the DB.
For me at least, all is well.
Lance|||
Ok, the pieces of the puzzle are finally complete. Here is what I did:
1. used the traceon flag as mentioned above
2. gave the full server name (i.e. \\server\share) and NOT the path where the share is mapped (i.e. DO NOT USE F:\share).
I got a further complication, because apparently SQL server had trouble finding the block size used on that NFS server. To deal with that I created the db on local disk first, then used DETACH/ATTACH to move the database to the NFS share. Kind of a long process but it worked. This is along the lines of the comment posted on detach/attach in this same thread chain.
Connecting to SQL Server via a Lan Connection
Hi, I have developed a windows form application which connects to a sql server 2k database via the following conneciton string:
I think you have to change your Data source in the connection string to the Server Name (PC Name that the SQL server is installed on)
i.e.
Private con As New SqlConnection("Data Source=FredPC;trusted_connection=true;Initial Catalog=Database1")
Private con As New SqlConnection("Data Source=(local);trusted_connection=true;Initial Catalog=Database1")
This works fine for running locally but I need to give my Windows form application to other users on the lan and have them reach my database server. So next I tried:
Private con As New SqlConnection("WorkStation ID= E134017.nw.nos.Boeing.com;Data Source=(local);trusted_connection=true;Initial Catalog=Database1")
where E134017.nw.nos.boeing.com is the full network path to my computer
It does not work and results in "Server does not exist or access is denied"
I next went in SQL and turned on tcp/ip and still no luck.
Any ideas,
Fred
Hi FredI think you have to change your Data source in the connection string to the Server Name (PC Name that the SQL server is installed on)
i.e.
Private con As New SqlConnection("Data Source=FredPC;trusted_connection=true;Initial Catalog=Database1")
Connecting to SQL Server over the LAN
Hello,
I have SQL Server installed on a machine named SQLHOST with an IP
address 192.168.1.4, and the SQL server is installed with the instance
named 'CLIENTDB'. Now on another machine, I have a client software
written using .NET which connects using the following string:
Server=SQLHOST\CLIENTDB;Initial Catalog=clients;User
ID=clientdb;Password=xyz;Trusted_connect
ion=false; Persist Security
Info=false;Pooling=false;
This works fine. But when I replace "SQLHOST" with "192.168.1.4" it
does not connect. Why is this? Is there no way one can connect with an
IP Address? As this is going to be deployed across the LAN, I would
rather rely on the IP address than the computer name... Does this make
sense?
Looking forward to your reply,
Thanks in advance,
JimHello Jim,
The instance name is significant in connecting to SQL Server. Try using 192.
168.1.4\CLIENTDB.
> I would
> rather rely on the IP address than the computer name... Does this make
> sense?
Yes, but not the way you are doing it. You'd be better off to get DNS setup
and going first so you can easily change the dotted-quad for SQLHOST without
having redeploy your app...
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||Hello Kent,
Thank you for the quick reply.
I tried using 192.168.1.4\CLIENTDB but I get an error saying SQL
Server or instance name not found. The only way it has worked is by
supplying the computer name...
I can not set up a DNS system right now as we are very low on time.
Thanks again,
Regards,
Jim
On Mar 21, 4:15 pm, Kent Tegels <kteg...@.develop.com> wrote:
> Hello Jim,
> The instance name is significant in connecting to SQL Server. Try using 19
2.168.1.4\CLIENTDB.
>
> Yes, but not the way you are doing it. You'd be better off to get DNS setu
p
> and going first so you can easily change the dotted-quad for SQLHOST witho
ut
> having redeploy your app...
> Thanks!
> Kent Tegels
> DevelopMentorhttp://staff.develop.com/ktegels/
I have SQL Server installed on a machine named SQLHOST with an IP
address 192.168.1.4, and the SQL server is installed with the instance
named 'CLIENTDB'. Now on another machine, I have a client software
written using .NET which connects using the following string:
Server=SQLHOST\CLIENTDB;Initial Catalog=clients;User
ID=clientdb;Password=xyz;Trusted_connect
ion=false; Persist Security
Info=false;Pooling=false;
This works fine. But when I replace "SQLHOST" with "192.168.1.4" it
does not connect. Why is this? Is there no way one can connect with an
IP Address? As this is going to be deployed across the LAN, I would
rather rely on the IP address than the computer name... Does this make
sense?
Looking forward to your reply,
Thanks in advance,
JimHello Jim,
The instance name is significant in connecting to SQL Server. Try using 192.
168.1.4\CLIENTDB.
> I would
> rather rely on the IP address than the computer name... Does this make
> sense?
Yes, but not the way you are doing it. You'd be better off to get DNS setup
and going first so you can easily change the dotted-quad for SQLHOST without
having redeploy your app...
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||Hello Kent,
Thank you for the quick reply.
I tried using 192.168.1.4\CLIENTDB but I get an error saying SQL
Server or instance name not found. The only way it has worked is by
supplying the computer name...
I can not set up a DNS system right now as we are very low on time.
Thanks again,
Regards,
Jim
On Mar 21, 4:15 pm, Kent Tegels <kteg...@.develop.com> wrote:
> Hello Jim,
> The instance name is significant in connecting to SQL Server. Try using 19
2.168.1.4\CLIENTDB.
>
> Yes, but not the way you are doing it. You'd be better off to get DNS setu
p
> and going first so you can easily change the dotted-quad for SQLHOST witho
ut
> having redeploy your app...
> Thanks!
> Kent Tegels
> DevelopMentorhttp://staff.develop.com/ktegels/
Connecting to SQL Server over the LAN
Hello,
I have SQL Server installed on a machine named SQLHOST with an IP address 192.168.1.4, and SQL server is installed with an instance named 'CLIENTDB'. Now on another machine, I have a client software written using .NET which connects using the following string:
Server=SQLHOST\CLIENTDB;Initial Catalog=clients;User ID=clientdb;Password=xyz;Trusted_connection=false; Persist Security Info=false;Pooling=false;
This works fine. But when I replace "SQLHOST" with "192.168.1.4" it does not connect. Why is this? Is there no way one can connect with an IP Address? As this is going to be deployed across the LAN, I would rather rely on the IP address than the computer name... Does this make sense?
Looking forward to your reply,
Thanks in advance,
Jimnetworking is not really my thing but I am wondering if you are using DHCP or static IP addresses. Can you ping that IP address from your machine? And excuse my networking ignorance but some times machines have an internal IP address and an external one.|||Hi,
Since you do not use the default instance, you should set the server to
"10.176.4.124\sql2005"
I could connect with this configuration to a server with IP 10.176.4.124 and instance name sql2005
Are you using "192.168.1.4\CLIENTDB" instead of "SQLHOST\CLIENTDB" ?
Eralper
http://www.kodyaz.com
I have SQL Server installed on a machine named SQLHOST with an IP address 192.168.1.4, and SQL server is installed with an instance named 'CLIENTDB'. Now on another machine, I have a client software written using .NET which connects using the following string:
Server=SQLHOST\CLIENTDB;Initial Catalog=clients;User ID=clientdb;Password=xyz;Trusted_connection=false; Persist Security Info=false;Pooling=false;
This works fine. But when I replace "SQLHOST" with "192.168.1.4" it does not connect. Why is this? Is there no way one can connect with an IP Address? As this is going to be deployed across the LAN, I would rather rely on the IP address than the computer name... Does this make sense?
Looking forward to your reply,
Thanks in advance,
Jimnetworking is not really my thing but I am wondering if you are using DHCP or static IP addresses. Can you ping that IP address from your machine? And excuse my networking ignorance but some times machines have an internal IP address and an external one.|||Hi,
Since you do not use the default instance, you should set the server to
"10.176.4.124\sql2005"
I could connect with this configuration to a server with IP 10.176.4.124 and instance name sql2005
Are you using "192.168.1.4\CLIENTDB" instead of "SQLHOST\CLIENTDB" ?
Eralper
http://www.kodyaz.com
Connecting to SQL Server over the LAN
Hello,
I have SQL Server installed on a machine named SQLHOST with an IP
address 192.168.1.4, and the SQL server is installed with the instance
named 'CLIENTDB'. Now on another machine, I have a client software
written using .NET which connects using the following string:
Server=SQLHOST\CLIENTDB;Initial Catalog=clients;User
ID=clientdb;Password=xyz;Trusted_connection=false; Persist Security
Info=false;Pooling=false;
This works fine. But when I replace "SQLHOST" with "192.168.1.4" it
does not connect. Why is this? Is there no way one can connect with an
IP Address? As this is going to be deployed across the LAN, I would
rather rely on the IP address than the computer name... Does this make
sense?
Looking forward to your reply,
Thanks in advance,
Jim
Hello Jim,
The instance name is significant in connecting to SQL Server. Try using 192.168.1.4\CLIENTDB.
> I would
> rather rely on the IP address than the computer name... Does this make
> sense?
Yes, but not the way you are doing it. You'd be better off to get DNS setup
and going first so you can easily change the dotted-quad for SQLHOST without
having redeploy your app...
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/
|||Hello Kent,
Thank you for the quick reply.
I tried using 192.168.1.4\CLIENTDB but I get an error saying SQL
Server or instance name not found. The only way it has worked is by
supplying the computer name...
I can not set up a DNS system right now as we are very low on time.
Thanks again,
Regards,
Jim
On Mar 21, 4:15 pm, Kent Tegels <kteg...@.develop.com> wrote:
> Hello Jim,
> The instance name is significant in connecting to SQL Server. Try using 192.168.1.4\CLIENTDB.
>
> Yes, but not the way you are doing it. You'd be better off to get DNS setup
> and going first so you can easily change the dotted-quad for SQLHOST without
> having redeploy your app...
> Thanks!
> Kent Tegels
> DevelopMentorhttp://staff.develop.com/ktegels/
I have SQL Server installed on a machine named SQLHOST with an IP
address 192.168.1.4, and the SQL server is installed with the instance
named 'CLIENTDB'. Now on another machine, I have a client software
written using .NET which connects using the following string:
Server=SQLHOST\CLIENTDB;Initial Catalog=clients;User
ID=clientdb;Password=xyz;Trusted_connection=false; Persist Security
Info=false;Pooling=false;
This works fine. But when I replace "SQLHOST" with "192.168.1.4" it
does not connect. Why is this? Is there no way one can connect with an
IP Address? As this is going to be deployed across the LAN, I would
rather rely on the IP address than the computer name... Does this make
sense?
Looking forward to your reply,
Thanks in advance,
Jim
Hello Jim,
The instance name is significant in connecting to SQL Server. Try using 192.168.1.4\CLIENTDB.
> I would
> rather rely on the IP address than the computer name... Does this make
> sense?
Yes, but not the way you are doing it. You'd be better off to get DNS setup
and going first so you can easily change the dotted-quad for SQLHOST without
having redeploy your app...
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/
|||Hello Kent,
Thank you for the quick reply.
I tried using 192.168.1.4\CLIENTDB but I get an error saying SQL
Server or instance name not found. The only way it has worked is by
supplying the computer name...
I can not set up a DNS system right now as we are very low on time.
Thanks again,
Regards,
Jim
On Mar 21, 4:15 pm, Kent Tegels <kteg...@.develop.com> wrote:
> Hello Jim,
> The instance name is significant in connecting to SQL Server. Try using 192.168.1.4\CLIENTDB.
>
> Yes, but not the way you are doing it. You'd be better off to get DNS setup
> and going first so you can easily change the dotted-quad for SQLHOST without
> having redeploy your app...
> Thanks!
> Kent Tegels
> DevelopMentorhttp://staff.develop.com/ktegels/
Connecting to SQL Server over the LAN
Hello,
I have SQL Server installed on a machine named SQLHOST with an IP
address 192.168.1.4, and the SQL server is installed with the instance
named 'CLIENTDB'. Now on another machine, I have a client software
written using .NET which connects using the following string:
Server=SQLHOST\CLIENTDB;Initial Catalog=clients;User
ID=clientdb;Password=xyz;Trusted_connection=false; Persist Security
Info=false;Pooling=false;
This works fine. But when I replace "SQLHOST" with "192.168.1.4" it
does not connect. Why is this? Is there no way one can connect with an
IP Address? As this is going to be deployed across the LAN, I would
rather rely on the IP address than the computer name... Does this make
sense?
Looking forward to your reply,
Thanks in advance,
JimHello Jim,
The instance name is significant in connecting to SQL Server. Try using 192.168.1.4\CLIENTDB.
> I would
> rather rely on the IP address than the computer name... Does this make
> sense?
Yes, but not the way you are doing it. You'd be better off to get DNS setup
and going first so you can easily change the dotted-quad for SQLHOST without
having redeploy your app...
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels|||Hello Kent,
Thank you for the quick reply.
I tried using 192.168.1.4\CLIENTDB but I get an error saying SQL
Server or instance name not found. The only way it has worked is by
supplying the computer name...
I can not set up a DNS system right now as we are very low on time.
Thanks again,
Regards,
Jim
On Mar 21, 4:15 pm, Kent Tegels <kteg...@.develop.com> wrote:
> Hello Jim,
> The instance name is significant in connecting to SQL Server. Try using 192.168.1.4\CLIENTDB.
> > I would
> > rather rely on the IP address than the computer name... Does this make
> > sense?
> Yes, but not the way you are doing it. You'd be better off to get DNS setup
> and going first so you can easily change the dotted-quad for SQLHOST without
> having redeploy your app...
> Thanks!
> Kent Tegels
> DevelopMentorhttp://staff.develop.com/ktegels/
I have SQL Server installed on a machine named SQLHOST with an IP
address 192.168.1.4, and the SQL server is installed with the instance
named 'CLIENTDB'. Now on another machine, I have a client software
written using .NET which connects using the following string:
Server=SQLHOST\CLIENTDB;Initial Catalog=clients;User
ID=clientdb;Password=xyz;Trusted_connection=false; Persist Security
Info=false;Pooling=false;
This works fine. But when I replace "SQLHOST" with "192.168.1.4" it
does not connect. Why is this? Is there no way one can connect with an
IP Address? As this is going to be deployed across the LAN, I would
rather rely on the IP address than the computer name... Does this make
sense?
Looking forward to your reply,
Thanks in advance,
JimHello Jim,
The instance name is significant in connecting to SQL Server. Try using 192.168.1.4\CLIENTDB.
> I would
> rather rely on the IP address than the computer name... Does this make
> sense?
Yes, but not the way you are doing it. You'd be better off to get DNS setup
and going first so you can easily change the dotted-quad for SQLHOST without
having redeploy your app...
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels|||Hello Kent,
Thank you for the quick reply.
I tried using 192.168.1.4\CLIENTDB but I get an error saying SQL
Server or instance name not found. The only way it has worked is by
supplying the computer name...
I can not set up a DNS system right now as we are very low on time.
Thanks again,
Regards,
Jim
On Mar 21, 4:15 pm, Kent Tegels <kteg...@.develop.com> wrote:
> Hello Jim,
> The instance name is significant in connecting to SQL Server. Try using 192.168.1.4\CLIENTDB.
> > I would
> > rather rely on the IP address than the computer name... Does this make
> > sense?
> Yes, but not the way you are doing it. You'd be better off to get DNS setup
> and going first so you can easily change the dotted-quad for SQLHOST without
> having redeploy your app...
> Thanks!
> Kent Tegels
> DevelopMentorhttp://staff.develop.com/ktegels/
Connecting to SQL SERVER over the Internet comes up with access denied error
I have set up an MSDE SQL Server in my Win XP Pro PC and am able to connect to it on the host PC, and over my LAN. However, when I try to connect to it over the Internet my connection is refused with the following message:
SQL server does not exist or access denied. ConnectionOpen (Connect())
Some background:
I have router/NAT firewall and have opened port 1433 (I have even tried a DMZ to the SQL Server machine). The Router is definitely going to the SQL Server PC! I am fairly certain that the connection string is correct.
Any help would be most gratefully received.
Are you using an aliased connection name for the server like DBServer or something instead of the IP? If so, make sure it is in DNS or your web servers host file.
Nick|||
Hi
Sorry for the delay... Had to shoot off elsewhere... Does this mean I have to have web services up and running on the PC that is hosting the SQL Database?
Thanks
Paul
|||It Depends. How are your web pages connecting to your sql server? Do you have 2 seperate boxes, one for web site other for sql server, or is it all on one server? Can you show your connection string to your server (remove the user name password info)?
Nick
|||Currently done have a web server at all! I am just trying to connect to the SQL database using an internet connection. I can use either a direct IP or NO-IP.com to connect to the PC. Its once I'm on the PC that I get kicked out by the SQL server.
Thanks
Paul
|||It sounds like you can make a connection to the server, but cant get authorization into the server? Try this:
Start>Control Panel>Admin Tools>Data Sources(ODBC)>System DSN>Add>SQL Server.
In the name, enter anything you want. For the server, enter the IP address and click next. Depending on how you connect (either with windows NT or SQL Server info into the machine, you will need to check the corresponding radio button. If you use NT and a different user name for SQL, uncheck the checkbox and enter your credentials and click next. If something is incorrect, it will tell you here. If not, you can make a good connection to your server. Let me know what it returns.
Nick
Hi! i'm having the same issue as Paul. I added the new datasource and it came up with this error:
Microsoft SQL Server ODBC Driver Version 03.85.1025
Running connectivity tests...
Attempting connection
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.
TESTS FAILED
i'm doing everything through NT auth and i'm on 2 servers. My work won't allow me to have an IIS and a SQL server on the same machine.
Any help would be great! thanks
Joel
Connecting to SQL Server from Web Server
This is probably a very basic question, but I'm not sure how to go about doing this. If I have a SQL server on our LAN and our Web server (running Microsoft Web Server OS) in my DMZ, and I want my Web server in the DMZ to be able to connect to the SQL server on the LAN, how do I go about doing that? Do I use an ODBC connection? I can't use SQL client tools because the Web Server OS will not allow me to install it. Any help would be great. Thanks in advance.
Ryan
Do you have it hooked up in your web.config file?
<connectionStrings>
<add name="LocalSqlServer" connectionString="Data Source=(local);Initial Catalog=DBNAME;Persist Security Info=True;User ID=XXX;Password=XXX;" providerName="System.Data.SqlClient"/
</connectionStrings>
Let me know.
|||Well, I can run the .asp script from the SQL server itself. So the web config should be good. Thanks for the quick reply.
|||The short answer is you can use anything you want, but you need to tell your firewall sitting between the DMZ and LAN to allow that type of traffic through the firewall.
A typical firewall rule would be to allow connections from your web server IP to your SQL Server IP over port X.
|||I will look at the firewall. What is the "preferred" method to access the DB?
Friday, February 10, 2012
Connecting to SQL Server Express in XP Home
I have SQL Server Express up and running on a PC, accessed via an ADP
I would like another PC on the LAN to do the same.
On the local machine everything works well, however the other machine cannot
connect.
I am using a trusted connection and the remote machine appears to be trying
to connect using DIMENSION9150\Guest
When I click "Test Connection" in Access I am presented with the following
error message:
"Test connection failed because of an error in initializing provider. Login
failer for user 'DIMENSION9150\Guest'"
Thanks in advance...The guest user has no connect privileges by default. You will have to grant
guest the privileges required.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"McHenry" <mchenry@.mchenry.com> wrote in message
news:443b6684$0$6811$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
>I have SQL Server Express up and running on a PC, accessed via an ADP
> I would like another PC on the LAN to do the same.
> On the local machine everything works well, however the other machine
> cannot connect.
> I am using a trusted connection and the remote machine appears to be
> trying to connect using DIMENSION9150\Guest
> When I click "Test Connection" in Access I am presented with the following
> error message:
> "Test connection failed because of an error in initializing provider.
> Login failer for user 'DIMENSION9150\Guest'"
> Thanks in advance...
>|||Roger, thanks for the prompt reply.
Without EM I am lost... is it possible in SQL Express ?
Thanks in advance...
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:eGi2RGXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
> The guest user has no connect privileges by default. You will have to
> grant guest the privileges required.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "McHenry" <mchenry@.mchenry.com> wrote in message
> news:443b6684$0$6811$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
>|||Try downloading this tool:
http://www.microsoft.com/downloads/...&displaylang=en
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"McHenry" <mchenry@.mchenry.com> wrote in message
news:443bc139$0$6801$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
> Roger, thanks for the prompt reply.
> Without EM I am lost... is it possible in SQL Express ?
> Thanks in advance...
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:eGi2RGXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
>|||Does it have to be the Guest account ?
I have the Guest account disabled for security reasons.
I tried to use a different account but was told that it was not associated
with a trusted connection.
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:eGi2RGXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
> The guest user has no connect privileges by default. You will have to
> grant guest the privileges required.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "McHenry" <mchenry@.mchenry.com> wrote in message
> news:443b6684$0$6811$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
>|||I'm not an expert in XP Home but my understanding is that it doesn't do
Windows authentication as anything but Guest.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"McHenry" <mchenry@.mchenry.com> wrote in message
news:443c5429$0$6834$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
> Does it have to be the Guest account ?
> I have the Guest account disabled for security reasons.
> I tried to use a different account but was told that it was not associated
> with a trusted connection.
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:eGi2RGXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
>|||Roger, I've downloaded the MS Management Studio Express as instructed...
Interestingly when I view security\users for my database "Guest" is already
listed however unlike the other users listed it's icon has a little down
arrow on it ?
Under security\logins for the server "Guest" is not listed, does this mean
that the Guest account has not server access rights and I need to add the
Guest account here ?
Thanks for your patience...
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:eGi2RGXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
> The guest user has no connect privileges by default. You will have to
> grant guest the privileges required.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "McHenry" <mchenry@.mchenry.com> wrote in message
> news:443b6684$0$6811$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
>|||you can enable the guest user with
GRANT CONNECT TO Guest
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"McHenry" <mchenry@.mchenry.com> wrote in message
news:443c9cc0$0$6826$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
> Roger, I've downloaded the MS Management Studio Express as instructed...
> Interestingly when I view security\users for my database "Guest" is
> already listed however unlike the other users listed it's icon has a
> little down arrow on it ?
> Under security\logins for the server "Guest" is not listed, does this mean
> that the Guest account has not server access rights and I need to add the
> Guest account here ?
> Thanks for your patience...
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:eGi2RGXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
>|||Roger, getting there...
After issuing them command GRANT CONNECT TO Guest in SQLCMD I can now see
that the guest account no longer has the little down arrow in it's icon
however the adp is still unable to connect.
I have viewed the event log on the sql server machine and have the following
events logged:
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 13/04/2006
Time: 9:17:02 AM
User: DIMENSION9150\Guest
Computer: DIMENSION9150
Description:
Login failed for user 'DIMENSION9150\Guest'. [CLIENT: 192.168.1.1]
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 18 48 00 00 0e 00 00 00 .H.....
0008: 0e 00 00 00 44 00 49 00 ...D.I.
0010: 4d 00 45 00 4e 00 53 00 M.E.N.S.
0018: 49 00 4f 00 4e 00 39 00 I.O.N.9.
0020: 31 00 35 00 30 00 00 00 1.5.0...
0028: 07 00 00 00 6d 00 61 00 ...m.a.
0030: 73 00 74 00 65 00 72 00 s.t.e.r.
0038: 00 00 ..
When I check details in MS Management Studio Express I see the following
which may or may not be relevant:
a) under Dimension9150\Security\Logins
=> the Guest account is not listed
b) under DIMENSION9150\Databases\IPS\Security\Rol
es\Database Roles
=> the only role that has a member is db_owner who'se sole member is dbo
Thanks Roger in advance...
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:%23vUZPymXGHA.3656@.TK2MSFTNGP05.phx.gbl...
> you can enable the guest user with
> GRANT CONNECT TO Guest
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "McHenry" <mchenry@.mchenry.com> wrote in message
> news:443c9cc0$0$6826$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
>|||Then create a login for DIMENSION9150\Guest
CREATE LOGIN [DIMENSION9150\Guest] FROM WINDOWS
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"McHenry" <mchenry@.mchenry.com> wrote in message
news:443daad2$0$32060$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
> Roger, getting there...
> After issuing them command GRANT CONNECT TO Guest in SQLCMD I can now see
> that the guest account no longer has the little down arrow in it's icon
> however the adp is still unable to connect.
> I have viewed the event log on the sql server machine and have the
> following events logged:
> Event Type: Failure Audit
> Event Source: MSSQLSERVER
> Event Category: (4)
> Event ID: 18456
> Date: 13/04/2006
> Time: 9:17:02 AM
> User: DIMENSION9150\Guest
> Computer: DIMENSION9150
> Description:
> Login failed for user 'DIMENSION9150\Guest'. [CLIENT: 192.168.1.1]
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Data:
> 0000: 18 48 00 00 0e 00 00 00 .H.....
> 0008: 0e 00 00 00 44 00 49 00 ...D.I.
> 0010: 4d 00 45 00 4e 00 53 00 M.E.N.S.
> 0018: 49 00 4f 00 4e 00 39 00 I.O.N.9.
> 0020: 31 00 35 00 30 00 00 00 1.5.0...
> 0028: 07 00 00 00 6d 00 61 00 ...m.a.
> 0030: 73 00 74 00 65 00 72 00 s.t.e.r.
> 0038: 00 00 ..
> When I check details in MS Management Studio Express I see the following
> which may or may not be relevant:
> a) under Dimension9150\Security\Logins
> => the Guest account is not listed
> b) under DIMENSION9150\Databases\IPS\Security\Rol
es\Database Roles
> => the only role that has a member is db_owner who'se sole member is dbo
> Thanks Roger in advance...
>
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:%23vUZPymXGHA.3656@.TK2MSFTNGP05.phx.gbl...
>
I would like another PC on the LAN to do the same.
On the local machine everything works well, however the other machine cannot
connect.
I am using a trusted connection and the remote machine appears to be trying
to connect using DIMENSION9150\Guest
When I click "Test Connection" in Access I am presented with the following
error message:
"Test connection failed because of an error in initializing provider. Login
failer for user 'DIMENSION9150\Guest'"
Thanks in advance...The guest user has no connect privileges by default. You will have to grant
guest the privileges required.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"McHenry" <mchenry@.mchenry.com> wrote in message
news:443b6684$0$6811$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
>I have SQL Server Express up and running on a PC, accessed via an ADP
> I would like another PC on the LAN to do the same.
> On the local machine everything works well, however the other machine
> cannot connect.
> I am using a trusted connection and the remote machine appears to be
> trying to connect using DIMENSION9150\Guest
> When I click "Test Connection" in Access I am presented with the following
> error message:
> "Test connection failed because of an error in initializing provider.
> Login failer for user 'DIMENSION9150\Guest'"
> Thanks in advance...
>|||Roger, thanks for the prompt reply.
Without EM I am lost... is it possible in SQL Express ?
Thanks in advance...
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:eGi2RGXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
> The guest user has no connect privileges by default. You will have to
> grant guest the privileges required.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "McHenry" <mchenry@.mchenry.com> wrote in message
> news:443b6684$0$6811$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
>|||Try downloading this tool:
http://www.microsoft.com/downloads/...&displaylang=en
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"McHenry" <mchenry@.mchenry.com> wrote in message
news:443bc139$0$6801$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
> Roger, thanks for the prompt reply.
> Without EM I am lost... is it possible in SQL Express ?
> Thanks in advance...
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:eGi2RGXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
>|||Does it have to be the Guest account ?
I have the Guest account disabled for security reasons.
I tried to use a different account but was told that it was not associated
with a trusted connection.
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:eGi2RGXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
> The guest user has no connect privileges by default. You will have to
> grant guest the privileges required.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "McHenry" <mchenry@.mchenry.com> wrote in message
> news:443b6684$0$6811$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
>|||I'm not an expert in XP Home but my understanding is that it doesn't do
Windows authentication as anything but Guest.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"McHenry" <mchenry@.mchenry.com> wrote in message
news:443c5429$0$6834$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
> Does it have to be the Guest account ?
> I have the Guest account disabled for security reasons.
> I tried to use a different account but was told that it was not associated
> with a trusted connection.
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:eGi2RGXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
>|||Roger, I've downloaded the MS Management Studio Express as instructed...
Interestingly when I view security\users for my database "Guest" is already
listed however unlike the other users listed it's icon has a little down
arrow on it ?
Under security\logins for the server "Guest" is not listed, does this mean
that the Guest account has not server access rights and I need to add the
Guest account here ?
Thanks for your patience...
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:eGi2RGXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
> The guest user has no connect privileges by default. You will have to
> grant guest the privileges required.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "McHenry" <mchenry@.mchenry.com> wrote in message
> news:443b6684$0$6811$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
>|||you can enable the guest user with
GRANT CONNECT TO Guest
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"McHenry" <mchenry@.mchenry.com> wrote in message
news:443c9cc0$0$6826$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
> Roger, I've downloaded the MS Management Studio Express as instructed...
> Interestingly when I view security\users for my database "Guest" is
> already listed however unlike the other users listed it's icon has a
> little down arrow on it ?
> Under security\logins for the server "Guest" is not listed, does this mean
> that the Guest account has not server access rights and I need to add the
> Guest account here ?
> Thanks for your patience...
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:eGi2RGXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
>|||Roger, getting there...
After issuing them command GRANT CONNECT TO Guest in SQLCMD I can now see
that the guest account no longer has the little down arrow in it's icon
however the adp is still unable to connect.
I have viewed the event log on the sql server machine and have the following
events logged:
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 13/04/2006
Time: 9:17:02 AM
User: DIMENSION9150\Guest
Computer: DIMENSION9150
Description:
Login failed for user 'DIMENSION9150\Guest'. [CLIENT: 192.168.1.1]
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 18 48 00 00 0e 00 00 00 .H.....
0008: 0e 00 00 00 44 00 49 00 ...D.I.
0010: 4d 00 45 00 4e 00 53 00 M.E.N.S.
0018: 49 00 4f 00 4e 00 39 00 I.O.N.9.
0020: 31 00 35 00 30 00 00 00 1.5.0...
0028: 07 00 00 00 6d 00 61 00 ...m.a.
0030: 73 00 74 00 65 00 72 00 s.t.e.r.
0038: 00 00 ..
When I check details in MS Management Studio Express I see the following
which may or may not be relevant:
a) under Dimension9150\Security\Logins
=> the Guest account is not listed
b) under DIMENSION9150\Databases\IPS\Security\Rol
es\Database Roles
=> the only role that has a member is db_owner who'se sole member is dbo
Thanks Roger in advance...
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:%23vUZPymXGHA.3656@.TK2MSFTNGP05.phx.gbl...
> you can enable the guest user with
> GRANT CONNECT TO Guest
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "McHenry" <mchenry@.mchenry.com> wrote in message
> news:443c9cc0$0$6826$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
>|||Then create a login for DIMENSION9150\Guest
CREATE LOGIN [DIMENSION9150\Guest] FROM WINDOWS
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"McHenry" <mchenry@.mchenry.com> wrote in message
news:443daad2$0$32060$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
> Roger, getting there...
> After issuing them command GRANT CONNECT TO Guest in SQLCMD I can now see
> that the guest account no longer has the little down arrow in it's icon
> however the adp is still unable to connect.
> I have viewed the event log on the sql server machine and have the
> following events logged:
> Event Type: Failure Audit
> Event Source: MSSQLSERVER
> Event Category: (4)
> Event ID: 18456
> Date: 13/04/2006
> Time: 9:17:02 AM
> User: DIMENSION9150\Guest
> Computer: DIMENSION9150
> Description:
> Login failed for user 'DIMENSION9150\Guest'. [CLIENT: 192.168.1.1]
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Data:
> 0000: 18 48 00 00 0e 00 00 00 .H.....
> 0008: 0e 00 00 00 44 00 49 00 ...D.I.
> 0010: 4d 00 45 00 4e 00 53 00 M.E.N.S.
> 0018: 49 00 4f 00 4e 00 39 00 I.O.N.9.
> 0020: 31 00 35 00 30 00 00 00 1.5.0...
> 0028: 07 00 00 00 6d 00 61 00 ...m.a.
> 0030: 73 00 74 00 65 00 72 00 s.t.e.r.
> 0038: 00 00 ..
> When I check details in MS Management Studio Express I see the following
> which may or may not be relevant:
> a) under Dimension9150\Security\Logins
> => the Guest account is not listed
> b) under DIMENSION9150\Databases\IPS\Security\Rol
es\Database Roles
> => the only role that has a member is db_owner who'se sole member is dbo
> Thanks Roger in advance...
>
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:%23vUZPymXGHA.3656@.TK2MSFTNGP05.phx.gbl...
>
Connecting to SQL server 2005 express in LAN Using C# express
I tried to connect to SQL server 2005 express in LAN Using C# express
I got this msg
the file \\blablabla\\blablabla.mdf is on a network path is not supported for database file.An Attempt to attach an auto-named database for file \\blablabla\blablabla.mdf failed. a database with same name is exist, or specified file can not be opened, or its located on UNC share.
Is that mean :
I can not connect to SQL server remotly using express edition of C#
SQL server dosen't support connection in LAN
I tried to set all options like enable TCP IP connection and networks
by the way
The data has unquie name and it is located in shared folder and I can easly to connect to database like access with no problem
I will be thankful if you can help me
With the Express Edition of SQL Server you can't connect to databases over LAN. Only local database are supported.|||Firstly Thank you very much to help me..
I read in features of sql express we can make the data in the server and shares the information with others clients. Also because sql express support web devlopment ASP that's mean the databse should be shared in the web ,, All that's mean sql server support to be in local area network !
please be sure, because I think visual C# express dosnt support client server database not sql server !
Im waiting for your comments :-)
|||I am able to connect to an instance of SQL Server Express from seperate machines on the same network using Server Management Studio Express CTP. So it appears access to SQL Server Express does work on a LAN.|||"a database with same name is exist, or specified file can not be opened, or its located on UNC share"
Is one of these three your problem? Is it a file shared on a network? Is the path+filename correct? Does a database with the same name already exists?
Let's rule those out first.
|||I have encountered the same problem attempting to create a .mdf database file on a network drive. The Knowledge Base, Article ID: 304261, states that if you turn Trace flag 1807 on that you can connect to a mapped or UNC network drive. But it doesn't work, as recommended, "http://msdn2.microsoft.com/en-us/library/ms176061.aspx, using the SQL statement "Create Database MyDB ON Primary "S:\blah\blah".It returns the error "Msg 5133, Level 16, State 1, Line 2
Directory lookup for the file "S:\colorlab\stores\_MouerMichael\TestingSQLX\MyLoc.mdf" failed with the operating system error 3(The system cannot find the path specified.)."
If I use the path "C:\blah\blah" - no problem.
Now I know the path is there and the OS finds it OK using other programs.
My goal is to move from a MSAccess DB on a network drive to a SQLExpress DB on a network drive.|||
Experiencing the same issue. I am also wishing to migrate from MSDE.
Using Microsoft SQL Server Management Studio Express I can create and populate a DB.
I wish to connect to it from VB express. However, I receive the error message that was listed in the first post in this thread.
My goal is to have SQL Server host a DB on a small network, allowing several workstations to access it concurrently.
How does one, or can one, share a DB using SQL Server Express?
Thanks in advance,
Lance
|||I have exactly the same problem and still no answer.
Everything can be done using Microsoft SQL Server Management Studio Express
with a local or remote connection, but I can't connect to a database to create a mdf or read, populate (...) an existing database with visual studio c# express.
There is only one way to connect to an SQL server with express studios (c#, VB ...) and it's by selecting an existing mdf file on remote server and it doesn't work at all.
If someone find a solution please post.
Thanks, vax
|||I am having the same problem. I tried setting trace flag 1807 like this:
dbcc traceon (1807,-1)
GO
But the management studio still doesn't seem to like my path (F:\) which is mapped to an NFS share. This is with SQL Server 2005 Enterprise Version.
Thanks
Eno
|||Here is what I have discovered to work.
1) Open the SQL Server Management Studio Express CTP and create a database.
2) Detach the database
3) Exit
4) Go to your language IDE of choice VB, C#, etc.
5) Create a new connection source to the DB you just created.
6) Go to the Solution Explorer and change the property "Copy to Output Directory" to 'Copy if newer'.
7) Close IDE
8) Open the SQL Server Management Studio Express CTP and reattach to the DB.
For me at least, all is well.
Lance|||
Ok, the pieces of the puzzle are finally complete. Here is what I did:
1. used the traceon flag as mentioned above
2. gave the full server name (i.e. \\server\share) and NOT the path where the share is mapped (i.e. DO NOT USE F:\share).
I got a further complication, because apparently SQL server had trouble finding the block size used on that NFS server. To deal with that I created the db on local disk first, then used DETACH/ATTACH to move the database to the NFS share. Kind of a long process but it worked. This is along the lines of the comment posted on detach/attach in this same thread chain.
Subscribe to:
Posts (Atom)