SQL Server 2005 connectivity Questions

1

Why can’t I connect to SQL Server 2005 through ODBC ?
Hello people, the situation is this: we have 2 computers, one is for local store (let’s call it backend) and the other is a web server (let’s call it frontend). Both are PCs running Windows Server 2003 SP2 and both have the SQL Server 2005 Enterprise Edition installed. The webserver is using IIS for ASP [...]

Answer Question   |  February 28, 2012  3:24 PM
ASP, ODBC Microsoft Access Driver Login Failed, SQL Server 2005 connectivity
asked by:
65 pts.

SQL Server 2005
Is user cloning the only way to use windows authentication in sql server?

Answer Question   |  October 9, 2010  3:34 PM
SQL Server 2005, SQL Server 2005 connectivity, SQL Server Express 2005, Windows 7, Windows authentication
asked by:
15 pts.

SQL 2005 keeps rebooting
My SQL 2005 server keeps rebooting. I can not figure out why. I get an NT SUbsystem message and then a 30 second countdown. This happens 20-40 times in a day. How can I fix it? I can not even run a virus scan to completion. Windows server 2008 SQL 2005. McAfee 8.7.1.

Answer Question   |  September 15, 2010  1:59 PM
McAfee, Reboot problem, SQL Server, SQL Server 2005, SQL Server 2005 connectivity, Subsystems, Windows Server 2008
asked by:
755 pts.

Local clients loose connection to local SQL Server when system network drops connection to HQ.
When line to primary Domain controller is dropped, some of the current logged on clients are dropped by SQL when they try to access the database.  For some clients, the application still works just fine. The clients are all set up and authenticated in the local Domain Controller. It is my thought that the authentication [...]

Answer Question   |  March 19, 2010  9:14 PM
Active Directory, SQL Server 2005, SQL Server 2005 connectivity, SQL Server connectivity, VB
asked by:
5 pts.

asked by:
5 pts.

sql server 2005 service will not start
I have a new server running server running windows 2003 and sql server 2005. when I turn on allow remote connections and restart sql service the service fails to start. If I turn off allow remote connections the sql service starts with no problems. I have been unable to find any potential solution to this [...]

Answer Question   |  May 26, 2011  10:16 PM
SQL Server 2005, SQL Server 2005 connectivity, SQL Server connectivity
asked by:
15 pts.

How to connect asp.net with sql 2005
I am trying to connect asp.net with sql2005 its not responding I am doing the contact us page where it will upload information to the database . the fields that im having is “Name,Surname,Email,Comments” it does connect but it doesnt up load to a database. Can you give some clues on how to code for [...]

Answer Question   |  February 26, 2010  1:57 PM
ASP.NET Web applications, SQL Server 2005 connectivity
asked by:
5 pts.

Failover issues in a SQL Server 2005 mirrored database
I have a SQL Server 2005 mirrored database with a witness. Everything seems to be working OK but I am having problems in the instance a failover occurs. Once the primary server goes down, my access to the database continues normally once both servers are back up and running and the old mirror is left [...]

Answer Question   |  June 25, 2009  4:23 PM
Database mirroring, DSN, Failover, SQL Server 2005, SQL Server 2005 connectivity, SQL Server Database Mirroring
2,585 pts.

Connecting to a SQL Server 2005 database through LAN
I am trying to connect to my SQL server 2005 database on my server. I open SQL server 2005 management studio and try to set the server name to IPADDRESSSERVER3 (the name of the server) but this doesnt work. I have also tried with connection strings in VB and these dont work either

Answer Question   |  March 5, 2011  9:06 AM
SQL Database, SQL Server 2005, SQL Server 2005 connectivity, SQL Server Management Studio 2005
asked by:
15 pts.

Replacement of CROSS APPLY statement
1. I am running query in which cross apply operator is used 2. That same query exceutes more than 10 times 3. Due to cross apply it increase the time to excute the report

Answer Question   |  July 8, 2009  8:12 AM
CROSS APPLY statement, SQL Server 2005, SQL Server 2005 connectivity
asked by:
10 pts.

Crystal Reports in Web application with SQL Server 2005 Express
i want to create crystal report in asp.net 2.0 web application with sql server 2005 express edition. now the name of my database which i have created its name is Database.mdf. now whenever i expert database i can find my server name but in the dropdownlist of database i can`t find my database name. there [...]

Answer Question   |  May 18, 2009  4:56 AM
ASP.NET 2.0, Crystal Reports, SQL Server 2005, SQL Server 2005 connectivity, SQL Server 2005 Express, Web applications, Web development
asked by:
10 pts.

Can’t create ODBC connection to sql 2005 instance
I have a server 2003 two node cluster with SQL 2005 installed. The orginal instance is working fine and there is no connection problem. I have created a second instance and can connect with the SQL Management Studio. When i try to create a ODBC connection from my client os both XP and VISTA both [...]

Answer Question   |  April 26, 2009  4:20 PM
ODBC, SQL Server 2005, SQL Server 2005 connectivity, SQL Server connectivity, SQL Server Management Studio, Vista, Windows Server 2003, Windows XP
asked by:
15 pts.

SQL Server Linked Server Security Context
Hey everyone, I’m working on some scripts that will run on a monitoring server and connect to several data servers to return information such as job status, etc. We also use linked servers for replication, etc. We use mixed authentication, however, I would like to change our linked servers to use the current security context [...]

Answer Question   |  March 28, 2009  1:56 PM
SQL Server 2005, SQL Server 2005 connectivity, SQL Server Linked Server, SQL Server security
asked by:
5 pts.

IBM System x3400 connectivity
We have brought IBM server x3400(7975PAT) which is running on windows server 2003 with SQL sewrver 2005 which is connected to 15 kiosks. I want to connect it to the one more server 2003 installed system to transfer data from the ibm server. How to connect ?

Answer Question   |  March 23, 2009  6:33 AM
IBM System x3400, SQL Server 2005, SQL Server 2005 connectivity, SQL Server interoperability, Windows interoperability, Windows Server 2003
asked by:
5 pts.

Data retrieval from TextBox and insert in to database
Hi i am learning c#2008 and asp.net3.5. I want to get data from my textbox control and insert it in database so i cant find any source code or presentation so please tell me how to do it or give me site address where i can find this Thanks

Answer Question   |  April 15, 2010  10:33 AM
ASP.NET, ASP.NET 3.5, C#, C# 2008, Database connectivity, Database programming, SQL connectivity, SQL Server 2005, SQL Server 2005 connectivity, TextBox
asked by:
5 pts.

1