all groups > sql server connect > february 2007 > threads for february 1 - 7, 2007
Filter by week: 1 2 3 4
How to make different instances of SQL Server visible to each other?
Posted by keith at 2/7/2007 9:28:54 PM
Two instances of SQL Server 2005 cannot "see" each other. One is Developer
edition and one is Standard edition. Standard editon is running under
Virtual PC. I would appreciate any suggestions on how make these two
instances visible to each other.
Thanks,
Keith
... more >>
Changing DB with a script using a variable.
Posted by Ray Laubert at 2/7/2007 6:49:01 AM
I am trying to write a TSQL Script for maintenance that willl read the
databases from sysdatabases and change to each database inturn to perform
some maintenance tasks.
Problem is I can't get SQL to change to the next database.
Tried Exec('Use' +@dbname) and it doesnt error out, but it also do... more >>
cannot generate sspi context when server in mixed authentication m
Posted by DBA72 at 2/6/2007 9:11:00 PM
We have a situation for which I have been trying to find an explanation for
over a week. A windows 2005 SP1 server which previously ran in Windows
authentication only suddenly caused "cannot generate sspi context" errors
after we switched it to mixed authentication mode.
-SQL service is run... more >>
Connection Problem VB.Net 2003 to SQL 2000
Posted by Fred at 2/6/2007 5:20:03 AM
Hi,
I have a webservice created in VB.NET 2003 hosted on a Windows 2003
server. This service inserts data into a SQL Server 2000 database also
hosted on a Windows 2003 server. The webserver is in a closed DMZ and
the Database Sever is on the internal network. The firewall is
configured to a... more >>
Access to SQL Server 2000 remotely
Posted by José at 2/5/2007 10:43:00 PM
I have installed SQL Server at my home computer. I can access from another
computer over internet. But from my company, I can't.
I talk to IT administrator, but he doesn't understand a lot abou this issue.
Any help?
What th IT should do to I have access?
Thanks,
Jose
... more >>
minimum speed to coonectSQL Server over inernet
Posted by José at 2/5/2007 10:39:01 PM
What the minimal speed is required to connect to SQL Server over internet to
give a good connection?
I mean where i can open forms, select item from the list boxes, generate
reports, inputing data...
Thanks
José
... more >>
NTWDBLIB.DLL
Posted by kapil at 2/4/2007 9:34:01 PM
We are using the NTWDBLIB.DLL to connect to SQL2005 via the BDE(Delphi). As
I understand it this DLL has been deprecated by Microsoft and therefore may
not work with future releases of SQL Server.
What is the likely future of the DLL, so we can understand the risks
associated with continui... more >>
Query remote server
Posted by yuval at 2/2/2007 12:19:25 AM
hi,
i have 2 sql2005 servers.
i am traying to drop , insert from one server to another,
and when i am trying to run simple query , i getting
an error:
"Msg 18452, Level 14, State 1, Line 1
Login failed for user ''. The user is not associated with a trusted SQL
Server connection."
the... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
cannot create job steps in 2005
Posted by Spicy Mikey at 2/1/2007 7:40:01 AM
I have a feeling this might be a security problem so I posting the question
in the security group as well. Sorry for the double post, I'll paste any
answers over there as well.
Here's the problem;
I'm trying to do some prototyping with SQL 2005 Standard - Full Text Search
in preparation f... more >>
|