all groups > sql server connect > march 2005 > threads for march 1 - 7, 2005
Filter by week: 1 2 3 4 5
My Server alias has stopped working. in VB.Net
Posted by Brian Link at 3/7/2005 9:10:34 PM
I've set up an alias for my laptop-clone of the production server with
the same name as that server (since I work disconnected most often).
This has worked swimmingly in the past. I went into Client Network
Utilities, "Added" a new alias, set the protocol to TCPIP, specified
an alias with the... more >>
Yet another "Login failed for user (null)".
Posted by Brian Link at 3/7/2005 3:30:02 PM
I've been running against SQL2k on a Win2k server which is also the
DC.
We just installed a new dedicated SQL box, and it is not a DC, but
exists in the same Domain.
I can talk happily to SQL on the DC, but using Windows Authentication
on the new machine is not working. I can connect using... more >>
Sql Server 2000 Remote connection options.
Posted by Cogo at 3/5/2005 2:30:14 PM
I'm using sql server 2000 in Delphi.
I have no any problem on my connection string in local network.
But, I can not make remote connect with this connection string.
I made port forward for 1433 and 1434 ports.
Can you give me different options by this way?
My connection string:
Provider=... more >>
Not associated with a trusted SQL Server connection
Posted by Dejan IvkoviƦ at 3/4/2005 10:03:09 AM
When I try to connect to SQL Server with windows NT authentication using the
network login ID from my machine (Win XP) it gives me SQL Server error
18452 - [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
user '(dejan)'. Reason: Not associated with a trusted SQL
Server connect... more >>
cannot connect to SQL Server via Query Analyzer
Posted by Marcello at 3/4/2005 1:33:00 AM
Hello, I am new to SQL and I would like to connect to a remote sql server.
I have Win 2k Professional installed at my PC and I have installation CD of
SQL Server 2000 Developer Edition.
I have chosen following options during installation:
SQL Server 2000 Components --> Install Database Server -... more >>
Can't write to SQL Table
Posted by Terry Olsen at 3/3/2005 8:28:14 PM
I'm not the SQL admin, but I'm trying to help fix a problem. Here's the
situation:
Microsoft SQL Server running Windows 2000 Server. Workstation connecting
via ODBC using SQL Driver.
We have a program on the workstation that pulls information from a single
table. There are over 800 table... more >>
Login Failed when I used Linked Server
Posted by Do Park via SQLMonster.com at 3/3/2005 7:42:26 PM
I created a linked server in SQL server in order to connect another SQL
Sever. I used the domain window account. I put my domain ID in Local login
and checked Impersonate in Security panel and I chose ?Be made using the
login?s current security context.
..
When I cliked the table under the Lin... more >>
Cannot open database requested in login 'northwind'. Login fails.
Posted by Pat Frost at 3/3/2005 6:37:02 AM
I work for DataDirect-Technologies. My customer is using our Connect for ODBC
5.00.0059 driver on Solaris 8 to connect to SQL Server 7 on Win 2000. When he
tries to connect using a simple C application he gets the error
"[DataDirect][ODBC SQL Server Driver][SQL Server]Cannot open database
re... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Error 8985 cannot locate file xxx in sysfiles
Posted by andy williams via SQLMonster.com at 3/2/2005 7:49:01 PM
I am attempting to shrink a datafile (I have 2 primary data files) when I
receive this error message 'Error 8985 cannot locate file xxx in sysfiles'.
I have repeatedly verified the data file name and even did a 'cut n paste'
into a query in qa dbcc shrinkfile with the same results. I have no
pr... more >>
requirements to connect to a named instance of MSDE 2.0
Posted by astro at 3/2/2005 4:49:54 PM
What is the propery syntax to establish a connection with a named instance
of MSDE on a server from a client workstation using the SQL Query analyzer
(or EM for that matter)?
I have tried "myServer\myInstance" to no positive effect.
Could I do this via TCP from a remote PC? What would ... more >>
Connection works for a while then gets this : [DBMSLPCN]SQL Server does not exist or access denied.
Posted by svallarian at 3/2/2005 7:53:42 AM
Situation:
We have some custom code running on microsoft great plains **under
terminal services** on a windows 2003 machine.
We have a program (running under great plains) that will run for about
5 minutes, then give the error
[Microsoft][ODBC SQL Server Driver][DBMSLPNCN]SQL Server does not ... more >>
ISQL Only letting Administrators Connect to SQL 7.0 Server
Posted by Brian Taylor at 3/2/2005 7:27:09 AM
We are running a 16-Bit application (I know, but we HAVE to run it).
Last night, the SQL Server was rebooted, and since then no-one can connect
to the SQL Server using ISQL. The error that is displayed is:
Error: 10004
Unable to connect: SQL Server is unavailable or does not exist. Access ... more >>
how to give proper permission for asp.net in sql server express
Posted by Chen Xiyang at 3/1/2005 10:50:46 PM
hi,
i have a problem which bothered me for a long time. i tried to connect
my asp.net page with sql server express 2005 and always got some error
msg telling that the current nt account doen't have enough permission.
i know this happens because i havn't given proper permission to the
int... more >>
SQL SERVER_ASP VBSRIPT_CONNECTION
Posted by dora at 3/1/2005 3:20:36 PM
i have one database with sql server
i want with asp vbsript to connect with database
my code is
<%
Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB; Data Source = (local); Initial Catalog =
Northwind; User Id = sa; Password="
If conn.errors.count... more >>
ASP SQL SERVER CONNECTION
Posted by dora at 3/1/2005 10:43:36 AM
how can i connect sql server with ASP vbscript?
thanks
... more >>
Cannot connect to Local SQL Server
Posted by Mark Lewis at 3/1/2005 9:37:09 AM
I am having trouble connecting to my local sql server from either the Server
Explorer or vb.net code. The problem is connected to the Norton Internet
Security 2005 Firewall as when I disable Norton everything works and if
Norton is enabled but the PC is not plugged into the network it also wor... more >>
Multiple select in a Store problem
Posted by Ste at 3/1/2005 8:52:20 AM
Hi, I have a problem...
Supposed that in a store procedure, I have two operation for example:
insert into mytable field1,field2 values ('bob','bobby')
select max(id) as id_last from mytable
go
in this case I have returned a recordset of one record, of last record
inserted, ok?
With ODB... more >>
|