Hi, My Windows XP client machines are using MDAC 2.8 SP1 to connect to a clustered SqlServer 2005 database. SqlServer definition says null values are acceptable in foreign key columns. But MDAC 2.8 SP1 says nulls are not accepted. The same application connecting to the same database/table fro...more >>

If I establish a remove connection to a server with pcAnywhere, will I be able to connect to SQL Server on that server programatically or with Enterprise Manager? Thanks for any help, WayneM...more >>

I have several developers that want access to my SQL server and I was wondering instead of giving them Remote desktop access to access Enterprise manager. I am going to install the SQL client tools locally on their PC. My SQL server is behind a firewall, does anyone know what port needs to b...more >>

Apolgies if this seems obvious. I am using Visual Studio and experimenting with SQL server databases. I can connect to Northwind and Pubs (the samples) and do simple selections on them. At work we have a personnel database which I am tesing at home. I can connect to it and explore the cont...more >>

Hi guys Hope someone can help me! I have tried to connect to the SQL Server using both TCP/Ip and Named Pipes and each time it shows a error Message SQL Server Error 17. I ran the Server Network utility and enabled Named Pipes and TCP/IP, It shows that Multiprotocol is also enabled. should i ...more >>

When I try to connect via IP to a newly created Active Active cluster I have to add the port to the IP for it to work. An example is if my IP is 10.0.0.1 and I try to connect it times out. if I try 10.0.0.1,1433 then it works fine. Am I missing a setting somewhere to make this work just by us...more >>

I'm trying to use the Upsizing Wizard on an Access database to SQL Server 2005. When I try to create the database I get a popup - Microsoft SQL Server Login - with the following information: Connection failed: SQLState: '01000' SQL Server Error: 53 [Microsoft][OBDC SQL Server Driver][DBNETLI...more >>

Hello: I get the following error message when I try to do a ODBC connection: Connection Failed: SQL State: '01000' SQL server Error: 11001 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()) Connection Failed: SQL State: '08001' SQL Server Error: 6 [Microsoft][ODBC...more >>

Hello, I'm writing am OSQL command to stop and start a remote Database. For the momente I use SHUTDOWN T-SQL command to stop the sevice: osql -U user -P pwd -S RemoteServer\MyInstance -q "shutdown" How do I restart the service? Thanks for any help on this question. Joao Rego ...more >>

Hello, What is the maximum number of active connections in SS2005 on Windows 2003 DC? Cheers SQLCatZ ...more >>

Hi all I have taken on a project from another developer and am experiencing some problems. To give some background, the application was running smoothly (client talks to web service, web service goes to database, web service returns data, client displays data). We then upgraded to SQL Serve...more >>

Dear sir/madam, I have a problem with my database. I want to restore MASTER, MSDB database. I have try to restore in normal mode but it doesn't allow, it requier to connect start in Single user mode. Once I start the server by command prompt "sqlservr.exe -m" and I reconnect using "sa" acco...more >>

Hello! I am trying to understand how connections are made to a SQL Server when the server is running on a different port. My SQL Server 2000 SP4 is configured to listen on port 465 for TCP/IP. I used the server network utility. My client has no idea of this but still manages to connect u...more >>

after installing sql server 2005, i messed up the login settings. I know can't login. i didn't really understand what i was doing short of uninstalling, reinstalling, do i have any options? also do you know of a tutorial for installing (setting windows vs sql authentication) and then se...more >>

I have been having a heck of a time connecting to a remote 2K5 instance from my local Management Studio. Each time I have tried to connect, regardless of the account, I have been greeted with "SQL Server does not exist/access denied" errors. I have configured the server to accept remote co...more >>

Can not make a new connection to SQL Server 2005 X64 until the SQL Server service is restarted. OS is Windows 2003 X64 Enterprise Edition all updates are applied. This repeats every few hours. Server protocols enabled are TCP IP and Named Pipes Client protocols are Named Piped only. The ...more >>

Hi, please help I am new with MS SQL Server. I do not have any problem with my local server but has problem with remote server. I am trying to connect my SQL database in my internet site. I want to design my database using "SQL Server Enterprise Manager" but I have received this erro...more >>

SQL 2000/SQL 2005(see below) running on Windows 2003 sp1, web server running IIS 5.0 on Windows 2000 sp4. Sometime in the first week of every month since at least Nov 2005, I get an Dbnetlib connectionopen(preloginhandshake()) error. Connections to the databases from the Web pages will be slo...more >>

Hi, I have an application which previous connect to SQL Server 2000. Now, I installed SQL Server 2005, and try to conncet to it. The previous connection string is: sString.Format("DSN=%s;uid=%s;pwd=%s", sDb, sUser, sPassword); In order to support SQL Native Client driver in SQL Server 2...more >>

About 3 years ago, I was told to create a SQL Server 2000 database for a client of ours, and to set up an Access XP/2002 project (adp) front end that would be used on their network to interact with the data. This database needs to be updated every six months. Since there has been some "feature ...more >>

Hello, I hope I'm posting this in the right group. I'm trying to connect to a network server running Sql Server 2005 Express from vb 2005. I can connect to it when I use: DATA SOURCE=<servername>\SQLEXPRESS;INITIAL CATALOG=<cat>;Integrated Security=SSPI; However I need to be able to conn...more >>

How can I run a select statement on data from a previous select statement within the same query? In VFP I could select the data into a cursor and then run the second select statement on the cursor. What is the best way to get this to run properly? Thanks. ...more >>

Hi I am trying to use the SQL Adapter in BizTalk 2004 against a SQL Server 2005. When trying to fire a stored procedure, I get the error you can see in http://www.eliasen.dk/biztalk/SQLSERVER2005ERROR.jpg Can anyone tell me what the cause of this can be? I have been to "Add/Remove windows c...more >>

Hello, We have installed SQL Server 2005 Express on a Windows XP box. The server instance's collation property is set to 'SQL_Latin1_General_CP1_CI_AS'. The collation for the databases we are connecting to via our application is set to 'SQL_Latin1_General_CP1_CI_AS' as well. However when l...more >>

Hi, I have a legacy db that was run using MSDE with an Access 2K ADP front end, all worked well. I now need access to the db again and have downloaded and installed SQL Server Express, I have also restored my database successfully and can view the tables using the Studio Express product....more >>

Upon a client connecting to the server, is there an 'OnClientConnected' -equivalent event on the server side that I can put some code to check who has just connected or what application or workstation is connecting? I'm looking for some way to check for 'valid' client applications....more >>

Dear ALL, I've a customer of mine asked me for a web hosting , and internet site contains a SQL database. It seems to be very simple but customer wants database at his office, so my problem is what is the most suitable solution to make communicate web and database remotely in order to ...more >>

I posted this in sqlserver.programming and did not get any responses. Trying again.. This bugged me in SQL2000 and seems to still be here in SQL2005. Here's repro code to run on two SQL2005 servers: Run this on the "remote server": Create Table RemoteTable (id int, txtdatacolumn text) ...more >>

Win2003 SP1 + SQL 2000 SP3 Sometimes, i have to restart SQL Server, because new users (on their regular PCs) cannont connecto to SQL. I have 100 SQL CAL licences, and 45-65 users. Sometimes a user disconnects, change to another's one PC and can connect. Maybe there is a relation with recent ...more >>

Why is it so hard to connect SQL2000 over Static IP? I thought it would be as easy as setting up a static ip with the ISP, and forwarding port 5000 from the router to the actual server box, and the sql2000 instance running on the server would listen to the port and do its thing... IT ain't wo...more >>

I have a client PC running a C# program that obtains data from an SQL Server database. The computer hosting the database is on a local network and is accessed by using the following connection string: Both computers are Windows XP SP2. "Data Source=192.168.20.124,1433;Network Library=DBM...more >>

I have a SQL 2000 server on a Windows 2003 server that i need to access with a different name from the same machine only. I added a hostname in the host file and associate it with the ip 127.0.0.1 In a test enviroment works fine but when i try to do the same in the real server i cant conn...more >>

I'm planning run a batch ( c:\CopyBkp.bat ) in a basis daily-night, basically it makes a copy of my full backup files on another machine in the net. The batch runs fine executed from a cmd window, but from Query analyzer (testing purpose) the instruction EXEC master.dbo.xp_cmdshell 'copy d:\b...more >>

Has anyone had any success with linked servers and DB2. My DB2 knowledge is very limited. EXEC sp_addlinkedserver @server = 'SERVERR2', @srvproduct = 'Microsoft OLE DB Provider for DB2', @provider = 'DB2OLEDB', @provstr='Network Transport Library=TCPIP;Network Address=10.73.102.115;...more >>

Hi, I'm a newbie to SQL Server 2005 and i've installed 180 days trial ver. When i tried to open the SQL Management Studio,i get the following error.Kindly help in resolving this issue. Regards, Shyam TITLE: Connect to Server ------------------------------ Cannot connect to SHYAMLAPT...more >>

Hello, I have PHP 5.0.2 on Apache2/WinXP and database on MS SQL 2005 express. I cannot connect to server: Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: TESTSERVER\SQLEXPRESS in C:\xxx\test.php on line 11 My source code test.php: .... $connectstring =...more >>

Hello, How does Yukon keep the information about the security context of xp_cmdshell (user or agent) ? How can we retrieve it ? I could not find a registery setting for that. Please help. Thanks a lot in Advance Regards, Vaibhav ...more >>

I tried to connect to a new created instance (specifying server\instance)in MSSQL2005 server with mangement studio in another mssql2005 server. It show an error 'An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caus...more >>

we are trying to execute a remote sql query from one sql server against another. Both servers are in the same domain. The query is a simple select * from tablename where surname = whatever. We precede this with an 'opendatasource' statement. The query returns only a few rows. When we run ...more >>

Hello dear all, I'm not sure if I'm posting to the right newsgroup, if not please direct me to the right one. I've installed "Microsoft SQL Server 2005 Express", and now I can log on only with windows authentication, I tried to follow : http://support.microsoft.com/kb/269587/en-us instruct...more >>

I need to change the port SQL Server 2000 Listens on to 6521 I have went into the SQL Server Utility and changed the port to 6521 I have also added this port to windows firewall exception list. However when I restart SQL Server, and run sp_readerrorlog, it is still not listening on 6521...more >>

Hi All, I am using OSQL to create database. When I am using it to create the database localy it works great when I use the -s switch (target manchine) the call ended successfuly only the database is created om my PC and not on the remote one. Does anyone know why? Thanks in advance Ore...more >>

Hello. I installed SQL Server 2005 on my XP Professional personal PC last night. Everything loaded OK. But when I tried to access some of the servces, I was prompted to connect to a server and the Server Name was blank. I guess my question is how do I set up my XP Professional to run as ...more >>

I have a Windows 2003 member server that has SQL on it. I have a remote XP machine in a workgroup that does have an account in the domain but does not login to the domain (only used for OWA). Is it possible for this machine to pass its authentication (same username and password) to the SQL se...more >>

Hi, I have installed SQL server 2005 Developer edition in my windows 2003 server. I have installed SQL server 2005 client tools in windows xp machine. When i try to connect to the server it says the following error. "An error has occurred while establishing a connection to the server. W...more >>

Hi all, Everything is fine until today. I have two instances(both msde databases, but I have enterprise manager and analyser installed) on my computer one instance is mssql and the other is mssql$netsdk (asp.net starter kit database) somehow the connection to mssql$netsdk is failed wh...more >>

will a client application using ado.net get an exception if the command is executing a stored procedure that does a RAISEERROR in its tsql? ...more >>

I recently got a new computer that I use to connect to a SQL 2000 Server and as soon as I started connecting to the server using QA and EM, the Air Force base communications center called saying they were showing 1700 failure to connect messages on ports, 1134,139, and 445. I connect just fine...more >>