1
vote
0answers
6k views

Cannot telnet to SQL Server on port 1433

I've been working solidly on this issue for the past three weeks. I cannot seem to find where the actual issue is. I just recently found this article on how to troubleshoot the connection. I made it ...
1
vote
2answers
31 views

MSAccess doesn't see sql2005 dataset

I have a sql2005 setup on a windows7 machine. I am able to see the dataset in SSMS, but am unable to create a connection string that will see the dataset from MSAccess. I am able to connect to the ...
3
votes
2answers
713 views

Why does my server lose SQL connection every 2-3 days (reboot fixes)?

Every 2-3 days, my Windows Server 2003 R2 Enterprise box which is hosting a .NET web app will start having an issue. The .NET app stops being able to connect to the SQL server with this error: An ...
1
vote
2answers
545 views

Native client connection from IIS to SQL Server 2005 through firewall takes over 30 seconds

I have a web server (IIS7/.NET 3.5 native client) connecting to SQL 2005 through a firewall. The server is on a cluster with a named instance configured to respond to the static port 1089. TCP ports ...
2
votes
3answers
289 views

SQL Server Standard/Enterprise Edition hosted differently from SQL Express

So SQL express in hosted on a machine, and I am assuming that SQL Enterprise or Standard is hosted on a dedicated server or something?? So I am a total rookie at this and am looking for learning ...
1
vote
1answer
51 views

Accessing SQL Server using SQL login

We have a SQL 2005 server, which is running on a Domain controller. When we access the database using a SQL login from the machine database server it works. When we access the same database using ...
1
vote
2answers
471 views

Cannot generate SSPI context

I'm trying to connect between two SQL Servers to set up log-shipping. I'm getting the following error when connecting from the Publisher to the Subscriber: Cannot connect to DRBOX Additional ...
0
votes
2answers
4k views

How to connect to a local SQL Server?

how to configure SQL Server 2005 for remote connection? I have to access a local SQL Server with a web application. Thank you!
2
votes
2answers
649 views

How do I configure SQL Server 2005 to accept a connection to a private or internal IP address on a private network?

I'm in unfamiliar territory, but here's the scenario: I have an application server and a database server, and both are on a private network. How do I allow connections from my app server to the ...
2
votes
3answers
3k views

Too many connections to SQL 2005

I have a situation where an application is over time opening a cumulative 6000 + connections to a 32 bit SQL2005 SP2 backend from a couple of app servers eventually causing internal memory pressure ...
4
votes
2answers
235 views

What permission is needed for my SQL Server 2005 DB for a WebUser?

I have a connection string in my asp.net code that looks at a SQL Server 2005 database. I created a UserName called WebUser and granted him db_datawriter and db_datareader in SQL Server 2005. Both ...