October 20, 2010 at 3:18 pm
Hello,
I am trying to make an odbc connection from a Windows XP pro Station to a Windows 2008 R2 Server with SQL 2008. When i do a command on the server "SQLCMD -L" i can see the server and the server instance of the SQL server so like:
<SERVERNAME>
<SERVERNAME>\SQLEXPRESS
Within the Server i can also make perfectly all odbc connections i want.
Coming to the client, when i do there a command "SQLCMD -L"i only get to see the servername
<SERVERNAME>
But bot the instance. When i still try to make a connection to thsi server with an odbc connection i get a message like "Sql server does not exist or acces is denied" SQl server error 10060
How can i make the instance available to the client?
Johan
October 20, 2010 at 3:22 pm
Express does not allow remote connections by default. Use sp_configure to change this
sp_configure 'remote access', 1
RECONFIGURE
October 20, 2010 at 3:25 pm
Thanks for your reply,
Where can i find this option?
October 20, 2010 at 3:27 pm
You run this as T-SQL
http://technet.microsoft.com/en-us/library/ms188787.aspx
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply