Click here to Skip to main content
15,896,111 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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

XML
<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

"
SQL
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
Posted

1 solution

try stopping and starting the SQL Server and SQL Server Browser services.
 
Share this answer
 
Comments
Aravindba 28-Mar-14 2:33am    
Hi thanks,i will stop server browser service now start,pls solve this issue also,click below link
http://www.codeproject.com/Questions/750624/How-to-solve-log-net-load-assembly-when-using-crys

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900