Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
August 2008


all groups > sql server connect > october 2003 > threads for october 29 - 31, 2003

Filter by week: 1 2 3 4 5

SQL Server service will not start, error 1058
Posted by Paul Aspinall at 10/31/2003 6:18:06 PM
Hi I have an SQL server, which (for some unknown reason) will not start as a service. Whenever it is tried to start (either using SCM, NET START, or Enterprise Manager), it reports the following error: "System error 1058 has occurred. The service cannot be started, either because it is ...more >>

Login Script?
Posted by J-M at 10/31/2003 7:51:15 AM
PROBLEM: I connect to multiple remote SQL Servers. QUESTION: Is there a script I can use in Query Analyser to connect to these Servers instead of using Connect from the File menu?...more >>

SQL connectivity restriction
Posted by Michael Kwok at 10/31/2003 12:21:57 AM
Is there any way to restrict user from using a certain protocl / access method to connect to SQL Server 2000 on server side? Like, I want USER A to connect with ODBC only while I want USER B to connect with DB-LIB only. Is it possible?...more >>

SQL 2000 ip change pros/ cons
Posted by Deepak at 10/30/2003 9:58:02 PM
hi all, I have a sql server 2000 on win 2k server, and some application's are using database residing on the server. now i need to change the ip address of my server, will this change affect the production... application's are connecting to server through server name not through ip, pl...more >>

stirng of connection
Posted by Joao Mossmann at 10/30/2003 7:53:32 PM
How to create one stirng of connection in SqlServer using integrated autencicação AD expecificando using and password of the AD? tanks joao ...more >>

Run-time error
Posted by Steve at 10/30/2003 12:10:33 PM
I'm getting this error when I try to connect to a SQL Server. Run-time error '-2147467259 (80004005)': Login failed for user '(null)'. Reason: No associated with a trusted SQL Server connection. Can someone please enlighten me. I have one other system that is able to to conne...more >>

stirng of connection
Posted by Joao Mossmann at 10/30/2003 11:29:55 AM
How to create one stirng of connection in SqlServer using integrated autencicação AD? tanks joao ...more >>

Named pipes causes intermittent freezing !
Posted by Robert Steadman at 10/30/2003 10:55:12 AM
We have a customer setup where all users were connecting via Named Pipes to a SQL 7 server (running on NT4). This was causing a periodic "freezing" in our application whereby all connections to SQL were made to wait around 30 seconds - even with just one user connected. (Our application accesses ...more >>



Rollback Process
Posted by td at 10/30/2003 9:27:27 AM
Hi all, Is there any way to stop a ROLLBACK process? Thanks Td ...more >>

Service account password change
Posted by dk at 10/30/2003 6:56:58 AM
I am changing the service account password. I am aware of four places where to change it:two services(sql server and agent) under services(win2000) and startup account password within sql server. Is there any other place that I am not aware of? Thanks...more >>

Connecting to SQL Server 2000 sitting behind XP firewall Problems
Posted by Roy Assaly at 10/30/2003 3:46:08 AM
Hi Everyone, Links, tips, whatever you can think of, I will take. Here is my setup: 1. Client 2. Internet 3. Windows XP (2 NICS) 4. HUB 5. MS Server Enterprise 2003 (running SQL Server) I can connect fine to the SQL server from my XP box. However, when I added the Alias in the Server...more >>

Watch that update
Posted by areatonlus at 10/30/2003 1:59:00 AM
Microsoft Consumer this is the latest version of security update, the "December 1996, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to pr...more >>

DSN Connection fails from DLL in ASP page
Posted by kamalesh NO[at]SPAM prathams.com at 10/29/2003 10:29:56 PM
Hello, I have designed an activeX DLL for database transaction. I am using this DLL from ASP page. I am using DSN for database connection. My Problem is I am able to connect to database, when I try to connect to database it gives message "Login Failed for User sa". The same DSN works if I con...more >>

sp_addlinkedsrvlogin problems
Posted by John Beatty at 10/29/2003 4:08:05 PM
Hi - When using linked SQL Server definitions, and using sp_addlinkedsrvlogin, is there any way to designate the remote user as a Windows Domain login? Given that OHIO is the Domain and OHIO\Joe is in the System Administrator role on the remote server; sp_addlinkedsrvlogin @rmtsrvname ...more >>

SQL-DMO BCP
Posted by Richard Brown at 10/29/2003 9:22:06 AM
I'm using SQL Server 7 and SQL-DMO within a Visual Basic program to do BCP. When I'm importing data I get an error message :- ODBC SQL SERVER DRIVER - SHARED MEMORY - SQL SERVER DOES NOT EXIST OR ACCESS DENIED - CONNECTIONOPEN(CONNECT()) With an error code of -2147221504. Can anyone ...more >>

Access Issue: Same Domain, Different HostNames
Posted by Zachariah at 10/29/2003 8:36:18 AM
We're getting our feet wet with Microsoft Access projects using a SQL Server 2000 back-end. We have three machines: DOM\JOHNSMITH : The developer's machine. DOM\FRONTEND: The remote front end machine. DOM\BACKEND: The remote SQL Server. We have user SMITHJ, who created an Access project on ...more >>


DevelopmentNow Blog