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
all groups > sql server connect > march 2004 > threads for march 1 - 7, 2004

Filter by week: 1 2 3 4 5

Arghhhh Alias (local)\FOOBAR -> TCP/IP,ditto
Posted by Alan J. McFarlane at 3/7/2004 2:00:56 PM
I've just spent days trying to get no-network protocol access to a local (MSDE )database working. Everything I tried failed, all hints from the documentation failed. Eventually...I found cliconfg.exe and found out about Aliases and found the stupid alias I referred to in the subject line, i.e...more >>


Looooong Delays Connecting with Enterprise Mgr
Posted by R.MacLean at 3/6/2004 1:53:08 PM
Ever since upgrading to SQL Server 2000, connecting to the DB servers with Enterprise Manager results in multi-minute delays while the database list populates. Is there something that can be done to make the connection process faster? ...more >>

I cannot create or modify a database in SQL server through Server Explorer in VS.NET 2003. How can I fix it?
Posted by aldo75 at 3/6/2004 11:36:10 AM
I cannot create or modify a database (SQL server 2000 Enterprise), through Server Explorer, in VS.NET 2003. I've installed MS .NET framework SDK 1.1 and VB.NET resource kit. How can I fix it?...more >>

Great difficulty in setting up SQL Server authentication for replication through non-trusted domains.
Posted by Joe Mine at 3/5/2004 5:14:14 PM
I have great difficulty in getting the subscriber SQL server in (HOT domain) to access the snapshot folder on the distributor/publisher SQL server in (NARC domain). They are non-trusted domains. I am aware that you must: 1) create a pass-through account on both Domains as eg. SQLadmin with same...more >>

Cannot connect to SQL Server through VPN
Posted by Paul Ohlemacher at 3/5/2004 5:13:05 PM
I established a VPN tunnel to my network at work to test merge replication. While I am able to connect via VPN to my network and ping the server in which the SQL server resides, I am not able to establish a connection to the Sql Server to register in my Enterprise Manager. The error I get is "Sq...more >>

attaching DAT files
Posted by Darius at 3/5/2004 3:15:41 PM
**** Post for FREE via your newsreader at post.usenet.com **** Hello, I have solved my problem with connecting to SQL 6.5. Thank you for answering. Still I have two more questions. I have copied DAT file from one computer with SQL 6.5 and put it to another computer with SQL 6.5. How can I ...more >>

SQL Server does not exist or access denied during updates
Posted by Jung Steutel at 3/5/2004 2:47:04 PM
Hi, I've got a problem connecting to a sql server 2000 (I think it's the standard edition) database running on a windows 2003 server (small business edition). I can connect to the database and retrieve data, but updates/inserts give the "sql server doesn't exist or access denied" error mess...more >>

SQL Statement Problem
Posted by Atley at 3/5/2004 2:26:06 PM
Sorry for the wide posting, but i really need some help and I posted somethind a few hours ago and have heard nothing, so i thought that I would try reacing more developers... I am trying to get a date range from the first of whatever month is previous to the current one to exactly one year pr...more >>



PDSSQL.DLL
Posted by Osvaldo Ospino at 3/5/2004 11:57:01 AM
THE LIBRARY PDSSQL.DLL CANNOT FOUND. I NEED THIS DLL. PLEASE HELP ME OSVALDO ...more >>

Connect to DB2 using SQL-Server
Posted by osoto at 3/5/2004 8:26:07 AM
Hello ther I have SQL 7 and ODBC-Client access to connect to DB2 (AS400). I can connect to the DB2 database using the ODBC and VB without problems but now I want to use the sp_addlinkedserver to link the DB2 to my SQL database using the ODBC. Does anybody know what parameters I have to use and what...more >>

MSDE - Move database from one MSDE instance to another MSDE instance
Posted by Phil at 3/5/2004 7:17:15 AM
I'm trying to move a database from one machine with MSDE installed to another machine with MSDE installed so that I can use this database on the 2nd machine. Is there a procedure in MSDE to copy/backup a database and restore to another machine? Thanks in advance....more >>

DSN or DSNless connection?
Posted by Vlad at 3/4/2004 4:37:04 PM
I'm starting to move my VB6 application from Access to SQL Server. In the beginning I'm going to use Access database with tables linked to SQL Server tables. Then form by form are going to be moved to direct SQL Server connection. When all of them are moved I delete Access. I have very weak expe...more >>

configuring sql 6.5
Posted by Darius at 3/4/2004 3:04:05 PM
**** Post for FREE via your newsreader at post.usenet.com **** Hi, I can't see SQL 6.5 server installed on other computer. I am trying to connect to it using SQL 2000, ODBC, ADO and none of this is helping. I haven't experienced the same problems with SQL2000 installation. I have installed ...more >>

Upsizing Access 2000 to SQL Server 2000
Posted by Shamim at 3/4/2004 2:56:42 PM
Hello, I am new to SQL Server. I am trying to use the Database upsizing wizard to upsize a Access 2000 database into SQL Server 2000. They are both on the same machine (running Win 03 Server). I cannot connect to the SQL Server. Error as below: Connection failed: SQLState: '01000' SQL ...more >>

Setting up pass through authentication for two SQL servers in non-trusted domains.
Posted by Joe Mine at 3/4/2004 11:23:57 AM
Hi, how do I configure pass through authentication for two SQL Servers in non-trusted domains for replication(to access the initial snapshot folder on the Distributor). If the subsciber is in the NARC domain and the Distributor/Publisher is in the HOT domain. How do I create a passthrough accou...more >>

Connecting from sql 2000 to sql 6.5
Posted by Darius at 3/4/2004 11:09:45 AM
**** Post for FREE via your newsreader at post.usenet.com **** Hello. I have two computers: one runing on SQL 6.5, other runing on SQL 2000. I want to connect to SQL 6.5 server from computer running on SQL 2000, but I can't see server runing on SQL 6.5. My SQL 6.5 is with sp5. How can I solv...more >>

Connecting to MySQL database
Posted by Dale Fye at 3/4/2004 10:51:06 AM
Anyone know how to connect to a MySQL database? I'd like to be able to just link to it or import several hundred Gig from this database into SQL Server 2K Any ideas?...more >>

SQL 2000 and Active directory
Posted by Xignals at 3/4/2004 8:43:36 AM
Would upgrading to Active directory from a NT4 domain slow down SQL Server communications to machines on the local network? Are there any changes that need to be made to the SQL server to speed up network access?...more >>

olap cube access problem
Posted by ha ha at 3/4/2004 5:46:18 AM
I just create a new olap cube from sql2000 and migrate an old cube from sql 7.0. I just create an vitual cube from sql2000 The user cannot access to the cube from the IIS ...more >>

Connecting to MS SQL from Linux?
Posted by george d lake at 3/3/2004 3:24:04 PM
Can this be done? and if so, where can I see some code? ...more >>

Active Directory Upgrade and SQL
Posted by Xignals at 3/3/2004 2:59:38 PM
Would upgrading to Active Directory from a NT4 domain have any effect on SQL Server 2000 SP3a? After our upgrade we started having connectivity issues with another server that it pulls data from over the internet going through ISA Server 2000. The AD upgrade was done on Sunday and the problem...more >>

Remote SQL Access Through ISA (SBS 2003)
Posted by anonymous NO[at]SPAM discussions.microsoft.com at 3/3/2004 11:48:18 AM
Hi All: Our Software vendor needs to log on to SQL Server (we have SBS 2003 Premium Edition)through ISA server. I have followed microsoft direction and have opened port 1433. He still cannot log on. He can log on through terminal services but has no access to sql server. I have tried my ...more >>

Shutting down SQL
Posted by RichK at 3/3/2004 11:37:55 AM
Hello All, I need to shutdown SQL for my Back-ups using Backup Exec. I used to have the Tape drive and Backup exec along with SQL on one server but since we upgraded to Win2000 I had to install the Backup and tape drive on one server while SQL is on another. My question is.....How can I shu...more >>

ole server login dialog box
Posted by Laura at 3/3/2004 11:34:27 AM
I am trying to connect to sql server 2000 from a windows 95 machine and windows 98. Both give me the same problem. There is no server listing in the login dialog box and it won't allow me to type it in. The error is unable to connect to data source. The workaround is to code it in the regis...more >>

Login failed for user '(null)'...Reasons?
Posted by JRE at 3/3/2004 10:27:44 AM
A SQL Server (in another domain) I'm trying to connect to with SQL Server authentication (UID and password) fails from an Access application. I've tried a ODBC DSN and a DSN-less connection. The SQL Server is running in mixed authentication mode. I can get to the SQL Server with Enterprise Man...more >>

how to configure connection pooling
Posted by Lance at 3/3/2004 10:02:11 AM
Hi, Is there a way to control the connection pools using SQL Server 2000? I know how to alter the connection string to do this(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguid e/html/cpconconnectionpoolingforsqlservernetdataprovider.asp), but I am looking for a setting i...more >>

Problems coneccting to BDE administrator
Posted by Elsa at 3/2/2004 9:16:07 AM
The sql server and bde administrator are in the same pc. I am not in network when I want to get connecting althought BDE it is not possible....more >>

Stored procedure;1
Posted by warway at 3/1/2004 6:13:37 PM
Can anyone tell me what ;1 means after a stored procedure name. It is only visible from some PCs in our network And they cannot run the stored procedures TIA Warway ...more >>

can't connect with OLEDB, but ODBC works
Posted by Dean at 3/1/2004 6:11:33 PM
I have a local database that I'm having trouble selecting as a source in DTS. I can connect just fine using "mymachinename", but if I try to use (local) or an alias in Client Network Utility, I get the error: Error Source : Microsoft OLE DB Provider for SQL Server Error Description : [DB...more >>

Change of data source from SQL to Oracle, Unix in DTS packets will there be problems?
Posted by Larsw at 3/1/2004 3:29:15 PM
Hi, I wonder if I can develop my DTS packets using an SQL server as data source and then later change to an Oracle database on UNIX? Will there be any problems? Best regards Lars-Åke ...more >>

Pushing data from Excel to a SQL server
Posted by Christian Davidsson at 3/1/2004 12:26:18 PM
Hello, Is it possible to feed a SQL server with data from an Excel sheet? If so - how? Thanks in advance, Christian Davidsson ...more >>

Unknown token received from SQL Server
Posted by Sonia at 3/1/2004 10:38:40 AM
"Unknown token received from SQL Server" , I get this message when I run a process on the SQL 7 Database. Can anyone help? ...more >>

newbie can't connect
Posted by Karl at 3/1/2004 9:07:55 AM
Windows XP pro, SQL Server 2000 developers edition installed on the = client computer. Installed SQL Server using all defaults except changed detination drive = and folders to D: Now the server does not run. I get the following error: SQL Server registration failed.... SQL Server does no...more >>


DevelopmentNow Blog