Connect to SQL Server 2005 from visual studio 2003

hello all,

i have SQL Server 2005 installed on a network computer and want to access it through code in asp.net. I am using visual studio 2003.

I have porvided this connection string to connect to that Sql Server 2005 Express instance but failed:

data source=mynetworkstystem\SQLEXPRESS;database=MobMatiLogs;User Id=sa;password=mobmasti786

But I get the error:

SQL Server does not exist or access denied.

Anyone please help me!

Thanks in advance

check the security permission on the network computer form Sql Server 2005 Manager and IIS Manager|||

Thanks ali for your reply!

But what permissions do you point to? And to me IIS Manager may not come in here. It seems purely SQL Server problem. Can you please guess and tell me some security permission on network computer as you said? As I have just installed SQL Server 2005 and can't understand or guess something.

I am waiting for your reply!

Thanks again!

|||Also make sure that you Enabled remote connections: http://www.sqlserver2005.de/Screencast/Screencast.aspx?ScreencastId=1

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de