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 > 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 >>



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 >>


DevelopmentNow Blog