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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|