all groups > sql server connect > october 2003 > threads for october 29 - 31, 2003
Filter by week: 1 2 3 4 5
SQL Server service will not start, error 1058
Posted by Paul Aspinall at 10/31/2003 6:18:06 PM
Hi
I have an SQL server, which (for some unknown reason) will not start as a
service.
Whenever it is tried to start (either using SCM, NET START, or Enterprise
Manager), it reports
the following error:
"System error 1058 has occurred.
The service cannot be started, either because it is ... more >>
Login Script?
Posted by J-M at 10/31/2003 7:51:15 AM
PROBLEM:
I connect to multiple remote SQL Servers.
QUESTION:
Is there a script I can use in Query Analyser to connect
to these Servers instead of using Connect from the File
menu?... more >>
SQL connectivity restriction
Posted by Michael Kwok at 10/31/2003 12:21:57 AM
Is there any way to restrict user from using a certain
protocl / access method to connect to SQL Server 2000 on
server side?
Like, I want USER A to connect with ODBC only while I
want USER B to connect with DB-LIB only.
Is it possible?... more >>
SQL 2000 ip change pros/ cons
Posted by Deepak at 10/30/2003 9:58:02 PM
hi all,
I have a sql server 2000 on win 2k server, and some
application's are using database residing on the server.
now i need to change the ip address of my server, will
this change affect the production... application's are
connecting to server through server name not through ip,
pl... more >>
stirng of connection
Posted by Joao Mossmann at 10/30/2003 7:53:32 PM
How to create one stirng of connection in SqlServer using integrated
autencicação AD expecificando using and password of the AD?
tanks
joao
... more >>
Run-time error
Posted by Steve at 10/30/2003 12:10:33 PM
I'm getting this error when I try to connect to a SQL
Server.
Run-time error '-2147467259 (80004005)':
Login failed for user '(null)'. Reason: No associated
with a trusted SQL Server connection.
Can someone please enlighten me. I have one other system
that is able to to conne... more >>
stirng of connection
Posted by Joao Mossmann at 10/30/2003 11:29:55 AM
How to create one stirng of connection in SqlServer using integrated
autencicação AD?
tanks
joao
... more >>
Named pipes causes intermittent freezing !
Posted by Robert Steadman at 10/30/2003 10:55:12 AM
We have a customer setup where all users were connecting via Named Pipes to
a SQL 7 server (running on NT4). This was causing a periodic "freezing" in
our application whereby all connections to SQL were made to wait around 30
seconds - even with just one user connected. (Our application accesses ... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Rollback Process
Posted by td at 10/30/2003 9:27:27 AM
Hi all,
Is there any way to stop a ROLLBACK process?
Thanks
Td
... more >>
Service account password change
Posted by dk at 10/30/2003 6:56:58 AM
I am changing the service account password. I am aware of
four places where to change it:two services(sql server and
agent) under services(win2000) and startup account
password within sql server. Is there any other place that
I am not aware of? Thanks... more >>
Connecting to SQL Server 2000 sitting behind XP firewall Problems
Posted by Roy Assaly at 10/30/2003 3:46:08 AM
Hi Everyone,
Links, tips, whatever you can think of, I will take. Here is my setup:
1. Client
2. Internet
3. Windows XP (2 NICS)
4. HUB
5. MS Server Enterprise 2003 (running SQL Server)
I can connect fine to the SQL server from my XP box. However, when I
added the Alias in the Server... more >>
Watch that update
Posted by areatonlus at 10/30/2003 1:59:00 AM
Microsoft Consumer
this is the latest version of security update, the
"December 1996, Cumulative Patch" update which fixes
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to pr... more >>
DSN Connection fails from DLL in ASP page
Posted by kamalesh NO[at]SPAM prathams.com at 10/29/2003 10:29:56 PM
Hello,
I have designed an activeX DLL for database transaction. I am using
this DLL from ASP page. I am using DSN for database connection.
My Problem is I am able to connect to database, when I try to connect
to database it gives message "Login Failed for User sa". The same DSN
works if I con... more >>
sp_addlinkedsrvlogin problems
Posted by John Beatty at 10/29/2003 4:08:05 PM
Hi -
When using linked SQL Server definitions, and using sp_addlinkedsrvlogin, is
there any way to designate the remote user as a Windows Domain login?
Given that OHIO is the Domain and OHIO\Joe is in the System Administrator
role on the remote server;
sp_addlinkedsrvlogin
@rmtsrvname ... more >>
SQL-DMO BCP
Posted by Richard Brown at 10/29/2003 9:22:06 AM
I'm using SQL Server 7 and SQL-DMO within a Visual Basic
program to do BCP. When I'm importing data I get an error
message :-
ODBC SQL SERVER DRIVER - SHARED MEMORY - SQL SERVER DOES
NOT EXIST OR ACCESS DENIED - CONNECTIONOPEN(CONNECT())
With an error code of -2147221504.
Can anyone ... more >>
Access Issue: Same Domain, Different HostNames
Posted by Zachariah at 10/29/2003 8:36:18 AM
We're getting our feet wet with Microsoft Access projects using a SQL Server 2000 back-end. We have three machines:
DOM\JOHNSMITH : The developer's machine.
DOM\FRONTEND: The remote front end machine.
DOM\BACKEND: The remote SQL Server.
We have user SMITHJ, who created an Access project on ... more >>
|