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 > april 2007 > threads for april 1 - 7, 2007

Filter by week: 1 2 3 4 5

Cannot see SQL Express 2005 from SQL Server 2k
Posted by Peter Croft at 4/6/2007 7:44:03 PM
I am running SQL Server 2k version 8.00 on one pc (A) on a lan, and SQL Express 2005 version 9.0 on another (B). I can see the 2k server on A from Management Studio Express on B but not the other way round. Is this a limitation or have I just done something wrong? Thanks in advance. Peter ...more >>

Specifying a server
Posted by Jeff Lederman at 4/5/2007 1:18:27 PM
I have a customer That's running Sql Server version 8 on his main server. He also has a 2005 version on a second server on the same network. I am trying to connect to the 2005 server via the web, but can only seem to access his main server. Is there any way to specify a port or a named ins...more >>

sql2000 instance connection problem
Posted by Gultekin KOMANLI at 4/5/2007 9:42:51 AM
Hi All, I'm unable to make connection to my sql2000 instance, I tried to search the knowledge base on msdn and failed with their solutions (defining alias). Can you give me some advice on this ? Cheers. Gultekin KOMANLI ...more >>

MSSQL2005 SP2 and DB-Lib Connection
Posted by mason at 4/4/2007 12:00:00 AM
We have some legacy processes written in C with embedded SQL. They were compiled with MSSQL2000 libraries and used db-lib for database connections. After the database was upgraded to MSSQL2005, they could still make the connection. Recently we have applied MSSQL2005 service pack 2 on the test ...more >>

Login Failed for user
Posted by Sajith at 4/3/2007 11:00:02 PM
Hi all, I have these lines repeated many times, every 1 second, in the error log: Login failed for user 'user' Login failed for user 'sa' Login failed for user 'root' Login failed for user 'admin' Is someone trying to hack my SQL server (version is 2000)? How can I control an...more >>

Connect to sqlexpress
Posted by SalamElias at 4/3/2007 10:06:03 AM
Hi, I have SQL 2005 developer edition on my laptop. I am wondering if it is possible to work with databases created for sql express edition. What I mean, is that I have VS 2005, I created a Personal web site starter kit. The wizard creates database files in the app_data directory. So is it po...more >>

ODBC connections error
Posted by mecn at 4/2/2007 5:33:53 PM
Hi, How do I disable in sql server ----- ansi quote identifiers in sql server. ansi nulls, padding, warnings. I set up an ODBC connection If I turn these off --- doesn't work , It works it tehy are checked. Any ideas? Thanks ...more >>

SQLExpresss losing connection to VB6 application
Posted by kocuba NO[at]SPAM ameritech.net at 4/2/2007 8:15:21 AM
I have a VB6 application that has MSDE as its current backend. In testing moving to SLSQLExpress I've noticed, since this application is run on laptops, that if I disconnect the network cable while I'm in the VB6 app I lose "connection" to the database. If I end task on the app and restart it i...more >>



No Client Protocols Enabled yet I can still get a DSN connection to SQL Server 2005
Posted by lacdn76 at 4/2/2007 8:13:21 AM
Perplexed...Why am I able to get a connection to my SQL Server from an Access 2003 database via DSN linked SQL server db table without a common protocol between the client and server? Could it be that the client does have TCP/IP or Named Pipes enabled but they are just not showing up in the cli...more >>

user does not have permission (error 15247)
Posted by Dan at 4/1/2007 12:00:00 AM
Hi, I have installed sql server 2005 express on a Windows xp system with windows authentification. I did this with my administrator account (dan). When i start sql server management studio, i see: user name: myserver\dan . Now i want to create a new login, so i rightclick on 'logins' in 'S...more >>


DevelopmentNow Blog