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 > september 2004 > threads for september 15 - 21, 2004

Filter by week: 1 2 3 4 5

Message: SQL Server does not exist or access denied.
Posted by Belinda at 9/21/2004 11:29:15 PM
Receiving the following error: Message: SQL Server does not exist or access denied. Source: .Net SqlClient Data Provider at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledCon nection(SqlConnecti...more >>


Slow connection from Windows 2003 application server to SQL Server
Posted by marc vermeulen at 9/21/2004 10:44:50 AM
Hello, We have the following problem: Separate application server and database server. Both Windows 2003. On both MSDTC 2.8 installed. Bith in same domain. Both in same network segment. When accessing the database via the application server, it seems that there is for each connecti...more >>

Best practices for remote users
Posted by STech at 9/21/2004 12:01:03 AM
Hi, What is the best practice to allow remote users that are not part of our domain to connect to a specific database on our server? Do we use Windows Authentication by adding them to the domain or do we use sql authentication. These users are in a different company and they will be logged on...more >>

SQL Server Error: 18452
Posted by anonymous NO[at]SPAM discussions.microsoft.com at 9/20/2004 3:23:15 PM
hi, i am having a difficult time trying to connect to my SQL server with the odbc drivers. i have it set to named pipes right now and when i try to switch back to tcp/ip, i come up with the above error, and says user 'null'. not associated with a trusted SQL server connection. here's what...more >>

Administering MSDE with Enterprise Manager
Posted by Andrew Chalk at 9/20/2004 1:42:59 PM
Can I administer SQL 2000 MSDE Release A from SQL Server's Enterprise Manager (EM) located on another machine on the same network? When I try to do this the EM setup wizard locates the host running MSDE but it cannot connect either with Windows authentication or the strong password created dur...more >>

ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link
Posted by jez123456 at 9/20/2004 12:41:03 AM
Hi, when using EM to open any table or diagram from a particular database I get the following message (no error number) ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure I’ve run DBCC CHECKDB and everything seems ok. I sometimes use ms access to view the data and...more >>

Problem with ASP & SQL ODBC connection
Posted by Patrick Tang at 9/19/2004 6:23:07 PM
Hi everyone, I need your expert advice. I have a w2k AD service with mssql on it. and I setup another w2k server with IIS on it as webserver. my website works on NT servers, but when I moved the website to the w2k server, it doesn't work. It saids: Error Type: Microsoft OLE DB Provider for...more >>

Unable to register new server in Enterprise Manager
Posted by Roger at 9/19/2004 6:02:06 PM
I've been looking at this problem for hours and hours - any help most gratefully received! I'm trying to set-up a test scenario between my desktop running SQL Server 2000 and my laptop (also running SQL Server 2000). Both machines are connected to a Netgear DG834G router, although if I har...more >>



Unable to Connect to SQL Server 2000
Posted by Butt Chin Chuan at 9/19/2004 12:05:28 PM
I got an extremely serious problem with SQL Server 2000 now. Without it, I couldn't start SQL and continue my programming work in SQL CE(I need both). Please kindly give me some help concerning the problem below: 1. When my pc starts, sometimes the SQL Server and the SQL Server Agent ...more >>

Unable to open Enterprise manager
Posted by chris at 9/19/2004 5:28:58 AM
Hi While I am trying to open enterprise manger it's showing the error login failed to the user,Even I am trying to use domain adminacct I am unable to open it.My sql server agent also not starting Chris...more >>

Installation/Connection problems with MS Desktop Engine
Posted by Steve Wash at 9/17/2004 10:35:43 PM
Actually, it appears to install fine. I used the command line parameters setup SAPWD="strongpassword" SECURITYMODE=SQL as the instructions described. I've tried with the double quotes and without. I've tried on a machine running Windows 2000 and XP (home addition). I tried updating the XP ...more >>

UDL no longer working on ONE PC
Posted by catalog information cannot be retrieved at 9/17/2004 1:18:56 PM
My Data Link (udl) files stopped working on just one of my pcs. The pc has been updated with mdac 2.8. I cant figure out what could have caused the 'corruption'? but i've tried creating a new one and get the same error. Any suggestions besides making sure MDAC is up to date? thanks jo...more >>

AS400 ODBC connection
Posted by Sandeep.khandelwal NO[at]SPAM gmail.com at 9/17/2004 12:47:53 PM
I was able to successfully create a linked server to AS400 box without any problem. But now, due to some reason the following query does not return any data (0 rows) Select * from openQuery(CWBIS800, 'select * from lib.tb where cmln = 10001001') whereas the following query does return the c...more >>

SQL Server and Windows XP SP2 - problems recognizing user in trusted connection
Posted by NoSpam at 9/17/2004 11:00:09 AM
Hi, I have SQL Server 2000 SP3a installed on Windows 2003 server. Client is Windows XP machine. Up to today I have no problems connecting to SQL Server - my Windows ID is assigned as SQL administrator. This morning I installed Windows XP SP2. I logged in to windowx XP using my usual userID (l...more >>

Use a Trusted Connection With OPENROWSET?
Posted by John at 9/17/2004 9:59:45 AM
Has anybody, anywhere figured out a way to use a trusted connection (Windows authentication) with OPENROWSET? The first two queries below used to work just fine because they use SQL authentication. The four queries after that are various sad, sad (and unworking) attempts I've made at using Wind...more >>

Connection issues
Posted by Jeff at 9/16/2004 9:48:05 AM
Hi all how about for SQL 2000 Enterprise? what are the concurrent connections? the reason I am asking is because I had an issue where we were getting asp errors/access denied during heavy traffic to our web servers/db servers. Our web server and db server are on 2 sep. machines. Pbvi...more >>

Telnet to IP on 1433
Posted by boman NO[at]SPAM biskopen.com at 9/15/2004 6:06:58 PM
I've had some problems connecting remotely to my named instance of SQL Server, so I started some usual troubleshooting. My original problem was that I can run EM locally without problems, but not remotely. After the usual checks I could think of I am down to this peculiar problem. There's o...more >>

weird timeout error
Posted by rajani at 9/15/2004 5:11:11 PM
Hi friends when i try to connect our sql server thru QA or EM i am getting timeout expired. It happens intermittently. whats weird is if i am already connected (i mean thru QA or EM ) then i can execute queries successfully. but if i try to login with new instance of QA then i get "timeou...more >>


DevelopmentNow Blog