Remotely access the SQL 2008 database

Question

Hi,

Merry Christmas and a Happy New Year to everybody.
I want to ask you kindly to help me how to access my SQL 2008 database which is on SQL server from my computer.
I tried with this page:
http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/
to enable remote access to SQL server database, but even though I did everything I read how to solve it, I can not connect to database form Microsoft Visual Studio 2008 from Server Explorer again.

Could anybody help me please?

Best wishes and thank you in advance.

Nel · Answer

Happy New Year and I wish you all the best. I have created the database in the SQL Server Management Studio. And in properties->Connections , Allow remote connections to this server is checked. I have created a connection also in the Visual Studio application. I followed all the procedure stated in http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx . But when I tried to set the permissions for the database, I created database role public and guset. Only by setting the guest nothing changed, but when I also entered public as role and set permissions I got an error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Grant failed for Database 'xxx'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.Grant&EvtID=Grant+Database&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Cannot grant, deny, or revoke the connect database permission to roles and application roles. (Microsoft SQL Server, Error: 4627) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=4627&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------

Pravin Ghadge · Answer

have u created data connection in data server?

Nel · Answer

I can see and chose the name of the server, but not the database I am looking for.

Pravin Ghadge · Answer

Hi Nel, wat problem u r facing?

Remotely access the SQL 2008 database

dlapkur

Mykonine