![]()
SQL Server error while connecting from ASP.net
Reply
![]() |
|
|
From:
DeepakKumar
|
Hi: Check out if you have not enabled TCP/IP
protocol ??
Steps to do so:
SQL Server 2005 - > Configuration Tools
-> SQL Server Configuration Manager -> SQL Server 2005
Network Configuration -> Protocols for SQL Server : Enable
TCP/IP
-- You should check the 'SQL Server Surface area
configuration' settings for your SQL Server 2005.
From SQL books online:
TCP/IP
<CONTENT
xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
TCP/IP is a common protocol widely used over the
Internet. It communicates across interconnected networks of computers with
diverse hardware architectures and various operating systems. It includes
standards for routing network traffic and offers advanced security features. It
is the most popular protocol used in business today. Configuring your computer
to use TCP/IP can be complex, but most networked computers are already properly
configured. To configure the TCP/IP settings that are not exposed in SQL Server
Configuration Manager, see your Microsoft Windows
documentation. Best Regards,
Deepak
Kumar.
MVP, MCDBA - SQL Server
----- Original Message -----
Sent: Monday, May 29, 2006 1:00 PM
Subject: SQL Server error while
connecting from ASP.net
SQL
Server error while connecting from ASP.net
Reply
|
|
| From: cmindz4u |
Hi
All,
I have
developed an application and it is currently hosted on my local
system, I am connecting to DB which is also available on my
local system. Application is working fine when both DB and code
is hosted on the same system. But when I try to put the code in
a different system, connect to the same DB and run the
application, it throws SQL server exception which is "SQL Server
does not exist or access denied. "
Connection
string I am using to connect is as below:
<add key
="ConnectionString" value="server=10.12.57.187;uid=sa;password
=pwd;database=abcd"/>
Can someone
help me resolve this problem.
Thanks for
all the help.
-
Srikanth | |
View other groups in this
category.
|
|
View other groups in this category.
![]() |
To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings.
Need help? If you've forgotten your password, please go to Passport Member Services.
For other questions or feedback, go to our Contact Us page.
If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list.
Remove my e-mail address from dotNET User Group Hyd.
|
|
- Re: SQL Server error while connecting from ASP.net DeepakKumar
-
