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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|