March 11, 2009 at 8:41 am
I just installed a new instance of SQL Server 2008 on a Windows 2008 server. I have all services enabled. I have added a user and granted all permissions for the server in Management studio on the Windows Server 2008 box. But when I come back to my laptop and try to connect to that instance with the username and password I added I get the following error: (I'm able to ping the Win 2008 server from my laptop as well)
TITLE: Connect to Server
------------------------------
Cannot connect to 5.103.214.199.
------------------------------
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. ( Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1326)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=1326&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
March 11, 2009 at 11:16 am
Check to see server allows remote connection and protocols like TCP/IP are is enabled in the SQL Server Configuration Manager and Surface Area configuration.
Thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 11, 2009 at 11:30 am
Yeah, TCP/IP was already enabled. Forgot to mentionthat before I guess.
March 11, 2009 at 11:54 am
Remote connection setting?
Server Properties
-> Connections
-> Allow remote connections ..
or
sp_configure 'remote access'
Thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 11, 2009 at 12:39 pm
Is SQL on default port (1433) and default instance name MSSQLSERVER?
If not, you have to specify it
or turn on SQL Browser
March 11, 2009 at 12:45 pm
I found the problem. The firewall was blocking me.
March 11, 2009 at 1:09 pm
Ha Do'h those dam things always getting in the way :D. Thanks for letting us know :).
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply