all groups > sql server connect > november 2005 > threads for november 15 - 21, 2005
Filter by week: 1 2 3 4 5
test
Posted by Capt America at 11/21/2005 8:22:37 PM
SQL Server does not exist or access denied.
Posted by pujarpatel at 11/20/2005 5:50:06 PM
am trying to run a simple .net code thro visual studio in which i just want
to display table data into datagrid from sql server running on my local pc.
i.e off localhost. but am getting run time error as below.
Do i have create a new asp.net user in sql server ? or what ? i have
searched ... more >>
More on that login problem - found the logs -
Posted by Barrett Bonden at 11/19/2005 12:59:16 PM
2005-11-18 12:50:12.09 logon Login failed for user 'sa'.
2005-11-18 12:50:36.85 logon Login succeeded for user 'NT
AUTHORITY\SYSTEM'. Connection: Trusted.
and some more that might be useful -
2005-11-18 12:50:40.92 logon Login succeeded for user 'NT
AUTHORITY\SYSTEM'. Connection: T... more >>
all of sudden cant connect with SQL server authentication
Posted by Barrett Bonden at 11/19/2005 12:29:01 PM
Can connect with Windows NT authentication, but not with SQL server auth. So
all my
code has stopped working ...
When I try to make a new SQL Server registration
I get server does not exist or access denied...
... more >>
HELP:SQL Port lost or never set on new install
Posted by jlopes151 at 11/18/2005 8:37:12 PM
I just installed SQL Server on XP (SP2) attempted to access the Server
through JDBC and got a error abut the socket connect. After much searching I
find that the port is not active even though all app that would set the port
have port 1433 set. If you follow. I ran netstat -ano and tasklist /s... more >>
LinkServer Available?
Posted by Mick Kowitz at 11/18/2005 12:00:00 AM
Hello,
Does anyone know an easy way to detect whether a LinkedServer is running
without waiting for the TSQL statement to timeout? In otherwords, is there
some secret stored proc or exe or some library that will allow me to write
code to detect whether the LinkedServer is up and running wit... more >>
Can not connect to non-default instance from remote computer
Posted by Alexey Rokhin at 11/17/2005 12:15:34 PM
I installed SQL2005 as default instance.
After that I installed SQL2000 with instance name "SQL2K". Then I installed
SP4.
I can'not connect to SQL2K instance from remote machine. But if I log on at
machine on which SQL Server installed I can connect to instance.
And I can connect to defau... more >>
How to Connect to SQL Server 2005 enterprise version
Posted by Willy Verbiest at 11/17/2005 12:00:00 AM
I've just installed sql server 2005 enterprise on my Windows XP Professional
SP2 machine.
I can't find a way to connect with it.
I'm totaly new to SQL Server and have installed it to learn about it.
I can' t even find out if it is running or not.
When I do a
c:>netstat -a
I can't find the po... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Connection Bombs Out at 3900+ records
Posted by Ginny at 11/16/2005 8:33:07 AM
I have a customer who's running an application that's using an OLE DB
connection to the database and when retrieving records a counter shows on the
screen. As soon as the count reaches somewhere between 3900 and 4000 the
counting stops and the grid never fills. The message received is as follo... more >>
Trusted Connection
Posted by Andrew Chalk at 11/16/2005 4:53:17 AM
On Windows XP running SQL Server, how do I create a user who will be
considered a "trusted connection?
I currently have SQL server set up for Windows Authentication? Do I have to
change this?
Perhaps someone could list the steps to create a trusted connection.
Many thanks,
... more >>
ASPNET User
Posted by Andrew Chalk at 11/16/2005 3:54:04 AM
My application attempts to connect to an SQL Server database as name ASPNET
and Login Name SERVERNAME/ASPNET in response to these commands:
SqlConnection myConnection = new SqlConnection("Data Source=(local);Initial
Catalog=MCSCRE;Integrated Security=SSPI");
myConnection.Open();
However, ... more >>
cannot connect using tcp/ip
Posted by Leo Deserio at 11/15/2005 1:17:12 PM
Hi,
I'm using SQL Server 2000 and I'm trying to connect via TCP/IP. When I test
it using telnet in port 1433, nothing happends.
I need to connect to this server via Internet.
How can I do?
Leo-
... more >>
Oracle Linked Server on SQL Server 2005 64-bit
Posted by imp at 11/15/2005 12:28:04 PM
Hello,
we are trying to migrate from SQL Server 2000 to SQL Server 2005.
On an 64 bit Windows 2003 SP1 Server we have installed an SQL Server 2000
Enterprise Edition and an SQL Server Enterprise Edition 2005 (64bit), both as
named instances.
On both SQL Servers we have configured Ora... more >>
Linked Server: set up same on different servers, but different res
Posted by smoss at 11/15/2005 9:19:02 AM
We have a linked server set up the same on 2 servers, but a query from one
server executes different on the remote database. A Query from one server
executes quickly, while the other causes table scans on the remote server,
per Profiler.
I couldn't see any differences on the query received on... more >>
|