Hai
I am delveloping website in one machine,but sql server is available in server machine,so how to access that sql database for my website.in my machine i will use connection string as
<add name="ConnectionString1" connectionString="Data Source=192.168.1.7\SQLEXPRESS;Initial Catalog=Employee;Persist Security Info=TRUE;User ID=XXXX;Password=XXXX" providerName="SQLOLEDB.1"/>
Connectionstring is ConnectionString1
sql Server Name in server machine is ADMIN-PC\SQLEXPRESS
Server Machine Ip address is 192.168.1.7
Database name is Employee
Sql Server Version is 2005
i am already enabled Shared Memory,Named Pipes,TCP/IP and VIA form sql Server Configuration Manager
And can ping server ip also form my machine,but if i use connectionstring as above it not work.it show message like
"
Exception occurred. 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Please Click Back Button And Try Again.
"
when i try to access sql database in my system form server machine.
Pls reply asap
Regards
Aravind