Tagged Questions

29
votes
5answers
19k views

A connection was successfully established with the server, but then an error occurred during the pre-login handshake

I am getting following error when i am trying to connect Production DB from Local Environment. I was able to connect Production DB before, but suddenly i am getting following error, any idea? A ...
5
votes
3answers
5k views

SQL Server: Native client vs. ODBC?

What is the difference between SQL Server Native Client connection and ODBC connection? What are the pros and cons of these two?
5
votes
2answers
274 views

All connections in pool are in use

We currently have a little situation on our hands - it seems that someone, somewhere forgot to close the connection in code. Result is that the pool of connections is relatively quickly exhausted. As ...
4
votes
1answer
5k views

Where are SQL Server connection attempts logged?

Does SQL Server has an external log file or internal table for attempted connections, or is that kind of info put somewhere in the Windows Event Log?
3
votes
1answer
243 views

sqlsrv_connect() keep connection in application pool active

I have a php script that connects to a local SQL server database through sqlsrv_connect. $serverName = "127.0.0.1\MSSQLSERVER"; $userName = 'username'; $userPassword = 'pass'; $dbName = ...
2
votes
5answers
119 views

How to minimize concurrent database connections?

My hosting company blocked my website for using more than 15 concurrent database connections. But in my code I closed each and every connection that I opened. But still they are saying that there are ...
2
votes
9answers
16k views

Connect to SQL Server 2008 with TCP/IP

I get the following error when I try to connect with TCP/IP from SQL Server Management Studio. I need a step by step description to solve my problem. What's wrong here? Cannot connect to ...
2
votes
1answer
750 views

Why are SQL Server 2008 queries so much slower against Localhost than remote server?

I'm working on an application with SQL Server 2008 as the backend. At the end of each day, I back up the database and restore it on my laptop so I can continue development at home. Everything works ...
2
votes
1answer
2k views

How to set-up SQL Server / IIS 7.0 to allow ASP.NET MVC website to access to database?

I have built an ASP.NET MVC 2 website that I am hosting with Rackspace Cloud Server using IIS 7.0. When I try to test the website under localhost with IIS 7.0 on the server I get an error page. This ...
2
votes
1answer
4k views

Classic ASP Remote SQL Connection String

I have a dilemma which is completely and utterly baffling me... We have a Classic ASP site which has been running for about a year, its powered via a local Win2008 SQL database (The SQL Express ...
2
votes
1answer
1k views

Cannot connect to Sql Server database: non-system databases are not shown

I'm trying to connect to SQL Server 2008 express database from Visual Studio 2010 using data connection wizard. I choose new connection -> MS Sql Server then I choose the only available server name ...
2
votes
1answer
366 views

Connect to SQL Server 2008 Database via C# [closed]

I am attempting to connect to a database I created in SQL Server 2008 on my computer. I have a Windows Authentication login which looks like this: try { string sCon = @"Data ...
2
votes
1answer
5k views

How can i connect to sql server from my android application?

I'm developing an android application. I need connect to sql server. I wrote a code for test connection but i get this error : java.sql.SQLException: Network error IOException: Permission denied ...
2
votes
2answers
882 views

ASP.NET application - Error when trying to connect to a SQL Server 2008 instance

Despite that I’m a regular reader of this great forum, this is my first post on it. I believe that this community can help me with the following problem that I have. I’m trying to publish an ASP.NET ...
2
votes
2answers
298 views

How do I log the Windows user, not service account, to database?

We have a .NET 4 web application running on our intranet. When a user starts the application, the user's Windows creds are checked to ensure the user is a member of the correct Active Directory ...

1 2 3 4 5 … 7
15 30 50 per page