I am using the connection string as
"Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=TMS_CHECK_CONVERSION;Data Source=PHILDCAP4Q\VENDOR" in
specified named instance is installed on the Respective machine.
It is giving the following error.,
Sqlserver does not exist or access denied.,
Please suggest ...?
Are you using Windows authentication on your SQL Server instance? If yes, is your SQL Server a member server in a domain?|||Yes I am using windows authentication only also sql server is a member server in the domain.
still I am getting the same error.
Any help is appericated.
|||Is this SQL Server 2000 or 2005? If it's SS2005, is your sql browser running? What are the protocols enabled on the server? Any firewall issue? You'd better follow the instruction here and give us more details. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1
|||
Named instance of SQL server is installed on Windows 2003 server.
And we are trying to connect to .Net with the follwoing connection string.,
Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=<Database Name>; Data Source= <Sql Server Installed Machine Name>\<Sql server instance Name>
we are getting the error as "SQL Server does not exist or access denied.
The information
[1] Client side:
What is the connection string in you app or DSN? (please specify)
Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=<Database Name>; Data Source= <Sql Server Installed Machine Name>\<Sql server instance Name>
If client fails to connect, what is the client error messages? (please specify)
Sql Server does not exist or access denied
Is the client remote or local to the SQL server machine? [Remote | Local]
Remote
Can you ping your server? [YES | NO ]
In cmd.exe console, type “ping -a <server_name>”.
Yes.
Can you telnet to your SQL Server? [YES | NO, please specify the error message ]
In cmd.exe console, type “telnet <server name> port, where port can be 135, 445 or sql_server_tcp_port. If your cmd.exe console turns into a complete black screen with a cursor flushing on top left corner, you are connected. Type ctrl+’[‘ to bring up telnet prompt and type “quit” <enter>.
Yes
What is your client database provider? [SNAC | MDAC | ADO.NET1.0 | ADO.NET2.0| other (please specify] Or/And, what is your client application? [SQL Management Studio | SQL Profiler | Visual Studio | Other (please specify).
MDAC Ver 2.8
Is your client computer in the same domain as the Server computer? (Same domain | Different domains | WorkGroup)
Yes
What protocol the client enabled? [Shared Memory | TCPIP | Named Pipes].
TCP/IP and Named Pipes
Do you have aliases configured that match the server name portion of your connection string? If so, please check if it is correct. You can use cliconfg.exe (SS 2000) or SQL Server Configuration Manager (SS 2005) to configure the alias.
No alias
Do you select force encryption on server and/or client?
No, theser are unchecked on both client server
[2] Server side:
What is the MS SQL version? [ SQL Server 2005 | SQL Sever 2005 ]
Sql server 2000 sp 4.
What is the SKU of MS SQL? [Enterprise | Standard | Workgroup | Express (or MSDE) | other (please specify)].
Enterprise
What is the SQL Server Protocol enabled? [Shared Memory | TCPIP | Named Pipes ]. Use SQL Server Configuration Manager to configure it and check ERRORLOG or event log to confirm.
TCP/IP and Named Pipes
Does the server start successfully? [YES | NO] If not what is the error messages in the SQL server ERRORLOG?
Yes.
If SQL Server is a named instance, is the SQL browser enabled? [YES | NO]
We are using sql server 2000, sp4.
What is the account that the SQL Server is running under?[Local System | Network Service | Domain Account]
Local system
Do you make firewall exception for your SQL server TCP port if you want connect remotely through TCP provider? [YES | NO | not applicable]
Don't know how to check this., Whether this is applicable for sql server 2000 also.,
Do you make firewall exception for SQL Browser UDP port 1434? [YES | NO | not applicable ]
Don't know how to check this., Whether this is applicable for sql server 2000 also.,
[3] Platform:
What is the OS version? [Windows XPSP2 | Windows 2003 | Windows 2000 | Windows 98 | others (please specify ) ].
Windows server 2003
Do you have third party antivirus, anti-spareware software installed? [Symantec | Norton | other (please specify)].
Yes. But I am not sure which is installed on customer's place.,
Thanks a lot.,
Any Help is really appriciated.
|||Chugupta,
"Do you make firewall exception for your SQL server TCP port if you want connect remotely through TCP provider? [YES | NO | not applicable]
Don't know how to check this., Whether this is applicable for sql server 2000 also.,
Do you make firewall exception for SQL Browser UDP port 1434? [YES | NO | not applicable ]
Don't know how to check this., Whether this is applicable for sql server 2000 also.,
"
You need to check both for your SQL2000 server. For SQL2000, you still need to make sure that your tcp port (Use ERRORLOG to check the value of the TCP port that your server is listening on) and UDP 1434 port are not blocked by the firewall. Mostlikely, they are blocked by firewall setting.
The following KB can give you a clue.
http://support.microsoft.com/?kbid=914277&SD=tech
|||
The most astonish thing here is., we are able to connect through delphi code and we are doing database operations. But when we are trying to connect the sql server through .Net it is throwing an exception sql server does not exist or access denied.
|||Can you post the exact connection string? I hope you are not using <>.
Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=<Database Name>; Data Source= <Sql Server Installed Machine Name>\<Sql server instance Name>
|||The connection string which I am using is
Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DBTest; Data Source= ServerPC\TestInstance
DBTest is the database name
ServerPC is the system where the sql server is installed
TestInstance is the name instance of sql server on ServerPc
Sql server is installed on Windows 2003 Server.
Using the above conncetion string I am able to connect the sql server using Delphi but not with .Net.,
When I am trying to connect through VB.Net it is throwing an exception "SQL Server does not exist or access denied.
|||Thanks for confirmation. I'm not sure how Delphi works, but can you make sure UDP port 1434 is not blocked? See the above post by Nan.
No comments:
Post a Comment