Connection String for Network SQL Server
-
Let me warn you I am new to SQL Server and network admin. I know I need to learn, but I don't even know where to start. I have found MS help to be almost useless, and the books I have seem to gloss over the "simple" things like getting a connection. So here I am in hopes that someone will help me out by providing some examples or by pointing me to some written material that can get me going.
I have a simple network with 5 clients, 3 wired, 2 wireless. I am running Windows Server 2008 and SQL Server 2008 Ent in a fresh installation. Using SQL Server Management Studio I can login on the server console. However, when I try to login from a network client using the same info I get an error message:
"The server was not found or as not accessible... (provider: Named Pipes Provider, error: 40-Could not open a connection to SQL Server)(Microsoft SQL Server, Error: 64)"
I haven't setup any specific logins or accounts in either SQL Server or Windows Server. I think that this is where the problem is, but I am not sure what to do.
Any help appreciated,
Tom
-
Couple things to check. Go to configuration Manager and check the protocols. Make sure Named pipes and TCP/IP are enabled under SQL Server Network Configuration and under SQL Native Client 10.0 Configuration. Also, can you connect through SSMS on a remote machine? If not, is your remote machine windows 7 or windows server 2008 with windows firewall on?
-
Definitely follow Toby's advice in the first instance, if this does not work then can you tell us a little bit more about the installation process please?
Is this a named instance? - If so is the SQL Browser service running?
What authentication mode did you choose? - (Windows or mixed)
Did you install SQL Server under a domain account? Was this account added as a sysadmin during the installation process?
Hope this helps,
Rich[p]
[/p] -
Thanks for the response!!!
For some reason today turned into the day from HELL! and I am buried under that brown stuff that smells bad. I am not ignoring your rely, it is just that work getting ahead of this work, if you know what I mean. I plan to work on this tonight and will get back to you as soon as....
Regards,
Tom
-
Hi to both Toby and rdouglass66:
Went to config mgr and made sure that Named Pipes and TCP/IP were enabled.
I can not connect using SSMS on my remote machine. I disabled the firewall to make sure that it was not causing a problem. It wasn't.
I have one server - i7 920, 12GB memory, 5 1.5TB drives in RAID. I am using the nic on the motherboard to connect to the network. I have a single Netgear router N150, which provides wireless as well as wired connectivity. I have DSL plumbed through the router. At this point I only have my Windows 7 laptop connected to the server via wireless connection. I am running SQL Server 2008 with all of the patches up to date. (That took some time!) The laptop I am using runs Windows 7 Ultimate.
I installed SQL Server as default. I used Windows Auth and installed logged in as the Administrator on the server.
If there is any more info you would like let me know. Thanks for the assist.
Regards,
TH
-
Hey,
You may have already tried this, but by default I don't think SQL 2008 enables remote connections.
Rright click the server in SSMS and click properties. Select Connections. Make sure "Allow remote connections to this server" is checked.
If that doesn't, try adding a user to SQL Server and connecting with those credentials instead of Windows. (you'll need to check SQL Server and Windows Authentication in the security tab of the server properties)
Good luck.
-Andrew
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply