SQL Server 2005 Connectivity Questions and Answers

Recent IT Questions

1 - 8 of 8
<<PREVIOUS 1 NEXT>>

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...

View Answer   |  Jun 25 2009  4:23 PM GMT
SQL Server 2005 connectivity, Failover, DSN
asked by SQL Server Ask the Experts

  2445 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 IPADDRESS\SERVER3 (the name of the server) but this doesnt work. I have also tried with connection strings in VB and these dont work either

asked by Providence

  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

asked by Archanaraghulohe

  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...

Answer Question   |  May 18 2009  4:56 AM GMT
SQL Server 2005, Crystal Reports, ASP.NET 2.0
asked by Softdeveloper

  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...

asked by Therockatmsu

  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...

asked by Lvance1611

  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 ?

View Answer   |  Mar 21 2009  6:33 AM GMT
IBM System x3400, Windows Server 2003, SQL Server 2005
asked by Ppaul

  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

View Answer   |  Nov 10 2008  10:33 AM GMT
ASP.NET, Database programming, SQL Server 2005
asked by Nimitparmar1987

  5 pts.

1 - 8 of 8
<<PREVIOUS 1 NEXT>>