Remotely access the SQL 2008 database

Nel

14y2.1k

Hi,
Can anybody help me please how to access the sql database remotely? I want to access the database on the SQL Server 2008 from my computer. Iallow remote connections to the server from SLQ Server Management Studio, allow the TCP/IP protocols in SQL Server Configuration Manager. I used the following sites http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx and http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/

Thanks

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nel14y ago
I solved it by installing Service Pack 1. But thanks anyway
0
Prabhu Raja14y ago
I think you are using VS 2008, thats the problem. SQL Server 2008 is Only supported in VS 2010.
0
Nel14y ago
Thank you to all of you for your help. I can access the database remotely now, but when I press test connection button I get an error :This server version is not supported. Only servers up to Microsoft SQL Servers 2005 are supported.
0
Mamta M14y ago
Try connecting to that database through SQL Server Management Studio (Shortcut: Type ssms in the Run window). See the error that you get there in the Studio. That will give you a clue what is going wrong.

Here is an excellent resource that can help you troubleshoot the connection errors:

http://msdn.microsoft.com/en-us/library/ms156468.aspx

Also check this

http://www.databasejournal.com/sqletc/article.php/1569851/Solving-SQL-Server-Connection-Problems.htm
0
Prabhu Raja14y ago
Hi,

Check your Connection by Clicking Test Connection Button in that (Add Connection) Window. If it Successful then you can Access the Databases from that Server.

Hope this url helps you : http://petermeinl.wordpress.com/2011/03/20/how-to-setup-sql-server-for-testing-with-visual-studio/

0
Nel14y ago
I open Visual Studio Server explorer, and click on Connect to Database (add connection), I chose data source (SQL Server name), but on Select or enter a database name in the combobox, I can't see the database name. In fact no database is shown in the combobox for chosin a database, and I can not connect remotely to the database
0
Mamta M14y ago
Where is the problem that you are facing?
0