asp sql server: March 2012

Tuesday, March 27, 2012

Connection Problem

Hello there
I have two servers on diffrent computer
Both of them are registered together
One of them declared as a publisher and the otherone as subscripter
When i add the subscript it gave me an error of connecting between them and
the synchronize is not active
where the problem can be?
Normally when you get the subscription is not active it means that your
publication is not activated.
in your publication database do this
sp_changepublication 'publicationname','status','active'
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Oded Kovach" <roygoldh@.hotmail.com> wrote in message
news:O8FBVRMlEHA.712@.TK2MSFTNGP09.phx.gbl...
> Hello there
> I have two servers on diffrent computer
> Both of them are registered together
> One of them declared as a publisher and the otherone as subscripter
> When i add the subscript it gave me an error of connecting between them
and
> the synchronize is not active
> where the problem can be?
>

Connection Problem

Hi All,
I can not connect to sql serve 2005 using SQL Serve Management Studio,
I got these error in ERROR.LOG file. Any help is really appreciated.
Thanks.
2006-09-21 12:48:21.53 Server Microsoft SQL Server 2005 -
9.00.2047.00 (Intel X86)
Apr 14 2006 01:12:25
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack
2)
2006-09-21 12:48:21.54 Server (c) 2005 Microsoft Corporation.
2006-09-21 12:48:21.54 Server All rights reserved.
2006-09-21 12:48:21.54 Server Server process ID is 4948.
2006-09-21 12:48:21.54 Server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2006-09-21 12:48:21.54 Server This instance of SQL Server last
reported using a process ID of 4396 at 9/21/2006 1:05:02 AM (local)
9/21/2006 8:05:02 AM (UTC). This is an informational message only; no
user action is required.
2006-09-21 12:48:21.54 Server Registry startup parameters:
2006-09-21 12:48:21.59 Server -d C:\Program Files\Microsoft
SQL
Server\MSSQL.1\MSSQL\DATA\master.mdf
2006-09-21 12:48:21.59 Server -e C:\Program Files\Microsoft
SQL
Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2006-09-21 12:48:21.59 Server -l C:\Program Files\Microsoft
SQL
Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2006-09-21 12:48:21.64 Server SQL Server is starting at normal
priority base (=7). This is an informational message only. No user
action is required.
2006-09-21 12:48:21.64 Server Detected 2 CPUs. This is an
informational message; no user action is required.
2006-09-21 12:48:22.64 Server Using dynamic lock allocation.
Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per
node. This is an informational message only. No user action is
required.
2006-09-21 12:48:23.65 Server Attempting to initialize Microsoft
Distributed Transaction Coordinator (MS DTC). This is an informational
message only. No user action is required.
2006-09-21 12:48:24.23 Server The Microsoft Distributed
Transaction Coordinator (MS DTC) service could not be contacted. If
you would like distributed transaction functionality, please start this
service.
2006-09-21 12:48:24.48 Server Database mirroring has been enabled
on this instance of SQL Server.
2006-09-21 12:48:24.84 spid5s Starting up database 'master'.
2006-09-21 12:48:25.42 spid5s SQL Trace ID 1 was started by login
"sa".
2006-09-21 12:48:25.46 spid5s Starting up database
'mssqlsystemresource'.
2006-09-21 12:48:25.54 spid5s The resource database build version
is 9.00.2047. This is an informational message only. No user action is
required.
2006-09-21 12:48:25.98 spid5s Server name is 'BLAHBLAH'. This is
an informational message only. No user action is required.
2006-09-21 12:48:25.98 spid9s Starting up database 'model'.
2006-09-21 12:48:26.46 spid9s Clearing tempdb database.
2006-09-21 12:48:30.10 spid9s Starting up database 'tempdb'.
2006-09-21 12:48:30.54 spid12s The Service Broker protocol
transport is disabled or not configured.
2006-09-21 12:48:30.54 spid12s The Database Mirroring protocol
transport is disabled or not configured.
2006-09-21 12:48:31.12 spid12s Service Broker manager has started.
2006-09-21 12:48:31.39 Server A self-generated certificate was
successfully loaded for encryption.
2006-09-21 12:48:31.40 Server Error: 26055, Severity: 16, State:
1.
2006-09-21 12:48:31.40 Server The SQL Server failed to initialize
VIA support library [QLVipl.dll]. This normally indicates the VIA
support library does not exist or is corrupted. Please repair or
disable the VIA network protocol. Error: 0x7e.
2006-09-21 12:48:31.42 Server Error: 17182, Severity: 16, State:
1.
2006-09-21 12:48:31.42 Server TDSSNIClient initialization failed
with error 0x7e, status code 0x60.
2006-09-21 12:48:31.43 Server Error: 17182, Severity: 16, State:
1.
2006-09-21 12:48:31.43 Server TDSSNIClient initialization failed
with error 0x7e, status code 0x1.
2006-09-21 12:48:31.43 Server Error: 17826, Severity: 18, State:
3.
2006-09-21 12:48:31.43 Server Could not start the network library
because of an internal error in the network library. To determine the
cause, review the errors immediately preceding this one in the error
log.
2006-09-21 12:48:31.43 Server Error: 17120, Severity: 16, State:
1.
2006-09-21 12:48:31.43 Server SQL Server could not spawn FRunCM
thread. Check the SQL Server error log and the Windows event logs for
information about possible related problems.Are you using VIA? If not, try disabling the protocol using
the SQL Server Configuration Manager.
-Sue
On 21 Sep 2006 21:58:12 -0700, "sara" <sarasara82@.gmail.com>
wrote:

>Hi All,
>I can not connect to sql serve 2005 using SQL Serve Management Studio,
>I got these error in ERROR.LOG file. Any help is really appreciated.
>Thanks.
>2006-09-21 12:48:21.53 Server Microsoft SQL Server 2005 -
>9.00.2047.00 (Intel X86)
> Apr 14 2006 01:12:25
> Copyright (c) 1988-2005 Microsoft Corporation
> Developer Edition on Windows NT 5.1 (Build 2600: Service Pack
>2)
>2006-09-21 12:48:21.54 Server (c) 2005 Microsoft Corporation.
>2006-09-21 12:48:21.54 Server All rights reserved.
>2006-09-21 12:48:21.54 Server Server process ID is 4948.
>2006-09-21 12:48:21.54 Server Logging SQL Server messages in file
>'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
>2006-09-21 12:48:21.54 Server This instance of SQL Server last
>reported using a process ID of 4396 at 9/21/2006 1:05:02 AM (local)
>9/21/2006 8:05:02 AM (UTC). This is an informational message only; no
>user action is required.
>2006-09-21 12:48:21.54 Server Registry startup parameters:
>2006-09-21 12:48:21.59 Server -d C:\Program Files\Microsoft
>SQL
>Server\MSSQL.1\MSSQL\DATA\master.mdf
>2006-09-21 12:48:21.59 Server -e C:\Program Files\Microsoft
>SQL
>Server\MSSQL.1\MSSQL\LOG\ERRORLOG
>2006-09-21 12:48:21.59 Server -l C:\Program Files\Microsoft
>SQL
>Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
>2006-09-21 12:48:21.64 Server SQL Server is starting at normal
>priority base (=7). This is an informational message only. No user
>action is required.
>2006-09-21 12:48:21.64 Server Detected 2 CPUs. This is an
>informational message; no user action is required.
>2006-09-21 12:48:22.64 Server Using dynamic lock allocation.
>Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per
>node. This is an informational message only. No user action is
>required.
>2006-09-21 12:48:23.65 Server Attempting to initialize Microsoft
>Distributed Transaction Coordinator (MS DTC). This is an informational
>message only. No user action is required.
>2006-09-21 12:48:24.23 Server The Microsoft Distributed
>Transaction Coordinator (MS DTC) service could not be contacted. If
>you would like distributed transaction functionality, please start this
>service.
>2006-09-21 12:48:24.48 Server Database mirroring has been enabled
>on this instance of SQL Server.
>2006-09-21 12:48:24.84 spid5s Starting up database 'master'.
>2006-09-21 12:48:25.42 spid5s SQL Trace ID 1 was started by login
>"sa".
>2006-09-21 12:48:25.46 spid5s Starting up database
>'mssqlsystemresource'.
>2006-09-21 12:48:25.54 spid5s The resource database build version
>is 9.00.2047. This is an informational message only. No user action is
>required.
>2006-09-21 12:48:25.98 spid5s Server name is 'BLAHBLAH'. This is
>an informational message only. No user action is required.
>2006-09-21 12:48:25.98 spid9s Starting up database 'model'.
>2006-09-21 12:48:26.46 spid9s Clearing tempdb database.
>2006-09-21 12:48:30.10 spid9s Starting up database 'tempdb'.
>2006-09-21 12:48:30.54 spid12s The Service Broker protocol
>transport is disabled or not configured.
>2006-09-21 12:48:30.54 spid12s The Database Mirroring protocol
>transport is disabled or not configured.
>2006-09-21 12:48:31.12 spid12s Service Broker manager has started.
>2006-09-21 12:48:31.39 Server A self-generated certificate was
>successfully loaded for encryption.
>2006-09-21 12:48:31.40 Server Error: 26055, Severity: 16, State:
>1.
>2006-09-21 12:48:31.40 Server The SQL Server failed to initialize
>VIA support library [QLVipl.dll]. This normally indicates the VIA
>support library does not exist or is corrupted. Please repair or
>disable the VIA network protocol. Error: 0x7e.
>2006-09-21 12:48:31.42 Server Error: 17182, Severity: 16, State:
>1.
>2006-09-21 12:48:31.42 Server TDSSNIClient initialization failed
>with error 0x7e, status code 0x60.
>2006-09-21 12:48:31.43 Server Error: 17182, Severity: 16, State:
>1.
>2006-09-21 12:48:31.43 Server TDSSNIClient initialization failed
>with error 0x7e, status code 0x1.
>2006-09-21 12:48:31.43 Server Error: 17826, Severity: 18, State:
>3.
>2006-09-21 12:48:31.43 Server Could not start the network library
>because of an internal error in the network library. To determine the
>cause, review the errors immediately preceding this one in the error
>log.
>2006-09-21 12:48:31.43 Server Error: 17120, Severity: 16, State:
>1.
>2006-09-21 12:48:31.43 Server SQL Server could not spawn FRunCM
>thread. Check the SQL Server error log and the Windows event logs for
>information about possible related problems.|||Yes. It was VIA protocol problem. Thanks.
Sue Hoegemeier wrote:[vbcol=seagreen]
> Are you using VIA? If not, try disabling the protocol using
> the SQL Server Configuration Manager.
> -Sue
> On 21 Sep 2006 21:58:12 -0700, "sara" <sarasara82@.gmail.com>
> wrote:
>sql sql

connection problem

I get the following message:
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (provider: Named Pipes Provider, error: 40 - Could not open
a connection to SQL Server)
From the following code:
<%@. Page Language="VB" Debug="true" %>
<script runat="server">
Dim ConnectionString As String = "server=
(local);database=ASPExamples"
Dim SelectCommand As String = "SELECT CustomerID, name, phone from
customers"
Dim isEditing As Boolean = False
Dim myConnection As New SqlConnection(ConnectionString)
Dim myCommand As New SqlDataAdapter(SelectCommand, myConnection)
Dim ds As New DataSet()
myCommand.Fill(ds)
DataGrid1.DataSource = ds
DataGrid1.DataBind()
End SubSee:
http://betav.com/blog/billva/2006/0...onnected_1.html
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Roger Halls" <roghalls@.gmail.com> wrote in message
news:Xns992A7925D4244roghallsgmailcom@.19
8.186.190.150...
>I get the following message:
> An error has occurred while establishing a connection to the server.
> When connecting to SQL Server 2005, this failure may be caused by the
> fact that under the default settings SQL Server does not allow remote
> connections. (provider: Named Pipes Provider, error: 40 - Could not open
> a connection to SQL Server)
> From the following code:
> <%@. Page Language="VB" Debug="true" %>
> <script runat="server">
> Dim ConnectionString As String = "server=
> (local);database=ASPExamples"
> Dim SelectCommand As String = "SELECT CustomerID, name, phone from
> customers"
> Dim isEditing As Boolean = False
> Dim myConnection As New SqlConnection(ConnectionString)
> Dim myCommand As New SqlDataAdapter(SelectCommand, myConnection)
> Dim ds As New DataSet()
> myCommand.Fill(ds)
> DataGrid1.DataSource = ds
> DataGrid1.DataBind()
>
> End Sub

connection problem

Hi, All,
SQL7.0, SP3 on Win2000 server+ sp1
I remote access our client in FL, recently I get error
message [DBNMPNTW] Connection write(writefile()) message
then the connection failed.
What's cause the problem how can I fix it.
Thanks and have a nice day
HawkHi Hawk,
Connection write using the Named Pipes library. There could be a
permission problem with Named Pipes /SMB or a restrictive Security Template
setting. Try connecting using TCP.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Kevin,
Thanks, but how can change it to TCP? Could you tell me
more?
Have a good weekend

>--Original Message--
>Hi Hawk,
> Connection write using the Named Pipes library.
There could be a
>permission problem with Named Pipes /SMB or a
restrictive Security Template
>setting. Try connecting using TCP.
>
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>|||Use the SQL Client Network Utility and create a TCP alias. Enter the
actual servername for the alias, this way the client will use sockets
instead.
If you have MDAC 2.6 on the client you can also try this as a test.
osql -Stcp:ServerNameHere -UuserName -Ppassword
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thank you very much and have a good one
Hawk

connection problem

Hi.
I have installed Microsoft SQL Server Desktop on Windows XP Pro. I can
connect to database from remote machines with Windows 98Se, but i can't
connect from machines with Windows XP.
ChrisI think that it is a problem with not having the 'correct' client network
utilities installed.
On the Start menu, select [All Programs], [Microsoft SQL Server], th
en
[Client Network Utility].
In the [Enabled Protocols] window, you should have both TCP/IP and Named
Pipes.
If one is missing, select the missing protocol from the list on the left
side, and click the [Enable] button.
Hopefully, if my memory is correct, that will take care of the problem.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Krzysztof" <colinkj@.poczta.onet.pl> wrote in message
news:eb0a61$jov$1@.nemesis.news.tpi.pl...
> Hi.
> I have installed Microsoft SQL Server Desktop on Windows XP Pro. I can
> connect to database from remote machines with Windows 98Se, but i can't
> connect from machines with Windows XP.
> Chris
>
>|||Have you tried temporarily disabling the firewall on the XP machines?
John Opincar
john.opincar@.sundesksoftware.com
"Krzysztof" <colinkj@.poczta.onet.pl> wrote in message
news:eb0a61$jov$1@.nemesis.news.tpi.pl...
> Hi.
> I have installed Microsoft SQL Server Desktop on Windows XP Pro. I can
> connect to database from remote machines with Windows 98Se, but i can't
> connect from machines with Windows XP.
> Chris
>
>

Connection Problem

Hi All,
I use the following code lines for connecting to SQL Server 2005 using
JDBC in Java:
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String connectionUrl =
"jdbc:sqlserver:// SERVER;user=USER;databaseName=db;Authent
icationMethod=auto
";
but I got the error: Login failed for user 'USER'
I want to use windows authentication and I am pretty sure I use the
correct username. Can you please help me?
Thanks a lot.AuthenticationMethod=auto is correct but you would not
supply a user in the connection string to have the
connection use Windows authentication. If you supply the
user, it will use SQL authentication, not windows.
-Sue
On 9 Oct 2006 00:56:14 -0700, "sara" <sarasara82@.gmail.com>
wrote:

>Hi All,
>I use the following code lines for connecting to SQL Server 2005 using
>JDBC in Java:
>Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
> String connectionUrl =
>"jdbc:sqlserver:// SERVER;user=USER;databaseName=db;Authent
icationMethod=aut
o";
>but I got the error: Login failed for user 'USER'
>I want to use windows authentication and I am pretty sure I use the
>correct username. Can you please help me?
>Thanks a lot.

Connection problem

I have 2 sql servers running on different machines. I want to manage both
servers from one machine. When I try to add the other server in the
enterprise manager it gives me the error "sql server does not exist or access
denied". I am using a valid log on user name that is set up on the server, I
have even tried using a windows username. I know that the problem has to lie
in authentication because I know the server exist. Anyone know of anything I
may be doing wrong?"Benjamin" <Benjamin@.discussions.microsoft.com> wrote in message
news:BBB264F3-FF58-40CD-9725-4BAC18E71A64@.microsoft.com...
> I have 2 sql servers running on different machines. I want to manage both
> servers from one machine. When I try to add the other server in the
> enterprise manager it gives me the error "sql server does not exist or
access
> denied". I am using a valid log on user name that is set up on the
server, I
> have even tried using a windows username. I know that the problem has to
lie
> in authentication because I know the server exist. Anyone know of
anything I
> may be doing wrong?
To rule out the server permissions issue, in other words your account has
permissions on the server itself -- try using an account that has
administrative rights on the target server and sysadmin permissions on SQL
Server.
Steve|||Ok here is what I tried. I went to the remote sql server and created a
windows user that is part of the admin group. I then went to the enterprise
manager on the remote sql server and created a user which I browsed for and
got from the windows users list. I gave that login SA rights on the sql
server. I then went back to the other server and tried to register the
remote sql server using sql authentication. I used the username and password
that I had created and I still get the same error message. Any ideas?
"Steve Thompson" wrote:
> "Benjamin" <Benjamin@.discussions.microsoft.com> wrote in message
> news:BBB264F3-FF58-40CD-9725-4BAC18E71A64@.microsoft.com...
> > I have 2 sql servers running on different machines. I want to manage both
> > servers from one machine. When I try to add the other server in the
> > enterprise manager it gives me the error "sql server does not exist or
> access
> > denied". I am using a valid log on user name that is set up on the
> server, I
> > have even tried using a windows username. I know that the problem has to
> lie
> > in authentication because I know the server exist. Anyone know of
> anything I
> > may be doing wrong?
> To rule out the server permissions issue, in other words your account has
> permissions on the server itself -- try using an account that has
> administrative rights on the target server and sysadmin permissions on SQL
> Server.
> Steve
>
>|||Another thing I forgot to mention. I also tried to register the other server
on the remote server (the reverse of what I have been trying). When I go to
register the server I see seven or so other servers that we have here at
work; however when I have been doing it on the other computer I only see one
server (that being the remote sql server). I am wondering what may cause
this and if it might have something to do with the login issue.
"Steve Thompson" wrote:
> "Benjamin" <Benjamin@.discussions.microsoft.com> wrote in message
> news:BBB264F3-FF58-40CD-9725-4BAC18E71A64@.microsoft.com...
> > I have 2 sql servers running on different machines. I want to manage both
> > servers from one machine. When I try to add the other server in the
> > enterprise manager it gives me the error "sql server does not exist or
> access
> > denied". I am using a valid log on user name that is set up on the
> server, I
> > have even tried using a windows username. I know that the problem has to
> lie
> > in authentication because I know the server exist. Anyone know of
> anything I
> > may be doing wrong?
> To rule out the server permissions issue, in other words your account has
> permissions on the server itself -- try using an account that has
> administrative rights on the target server and sysadmin permissions on SQL
> Server.
> Steve
>
>|||Other things I have tried:
Pinging the remote sql server - works fine
telnet to port 1433 on the remote server - does NOT work
there is not a firewall between the two machines.
"Steve Thompson" wrote:
> "Benjamin" <Benjamin@.discussions.microsoft.com> wrote in message
> news:BBB264F3-FF58-40CD-9725-4BAC18E71A64@.microsoft.com...
> > I have 2 sql servers running on different machines. I want to manage both
> > servers from one machine. When I try to add the other server in the
> > enterprise manager it gives me the error "sql server does not exist or
> access
> > denied". I am using a valid log on user name that is set up on the
> server, I
> > have even tried using a windows username. I know that the problem has to
> lie
> > in authentication because I know the server exist. Anyone know of
> anything I
> > may be doing wrong?
> To rule out the server permissions issue, in other words your account has
> permissions on the server itself -- try using an account that has
> administrative rights on the target server and sysadmin permissions on SQL
> Server.
> Steve
>
>|||Problem Solved: I was really simple actually, all I had to do was go to the
properties of the remote sql server and configure the network configuration
to enable tcp/ip using port 1433
"Steve Thompson" wrote:
> "Benjamin" <Benjamin@.discussions.microsoft.com> wrote in message
> news:BBB264F3-FF58-40CD-9725-4BAC18E71A64@.microsoft.com...
> > I have 2 sql servers running on different machines. I want to manage both
> > servers from one machine. When I try to add the other server in the
> > enterprise manager it gives me the error "sql server does not exist or
> access
> > denied". I am using a valid log on user name that is set up on the
> server, I
> > have even tried using a windows username. I know that the problem has to
> lie
> > in authentication because I know the server exist. Anyone know of
> anything I
> > may be doing wrong?
> To rule out the server permissions issue, in other words your account has
> permissions on the server itself -- try using an account that has
> administrative rights on the target server and sysadmin permissions on SQL
> Server.
> Steve
>
>sql sql

Connection problem

My VB 6 program uses this connection string to connect to the server:
user id=coord;data source=GS;persist security
info=True;Password=coord;initial catalog=CoordinatorTest
It works fine on all XP machines, but it doesn't work on only some of Vista
Business machines. It says Server doesn't exists or access denied. On some
other Vistas it works.
When I replace the name of the SQL Server with IP:
user id=coord;data source=10.22.52.4;persist security
info=True;Password=coord;initial catalog=CoordinatorTest
then it works.
I wouldn't want to create the different Connection strings for different
operating systems.
What's wrong with some of non working Vista's machines? What should be done
in order to make all of Vista machines work?
Thank you
vovan"vovan" <v@.v.com> wrote in message
news:%23v2T$CGEIHA.3332@.TK2MSFTNGP04.phx.gbl...
> When I replace the name of the SQL Server with IP:
> user id=coord;data source=10.22.52.4;persist security then it works.
It sounds like your Vista machines can locate data sources by IP address,
but not by hostname. You'd want to troubleshoot this as a general TCP/IP
Name resolution problem - make sure DNS Settings are correct; does a "ping
<hostname> from an Vista Command Line give same results as "ping <IP
address>"?; etc.
The Netdiag tool from the XP Support Tools also runs on Vista; just copy
over the netdiag.exe file from XP. Then run
C:\FOO>netdiag /v /debug
on the Vista machine, to run a comprehensive test for DNS and Domain
problems.
You don't say whether you're using ODBC, OLE DB, SQL Native Client, or what;
but generally, they should all work on Vista much the same as on XP. More
likely to be networking than compatibility, I'd guess.
Hope it helps,
--
Andrew McLaren
amclar (at) optusnet dot com dot au

Connection Problem

Hi All,
I can not connect to sql serve 2005 using SQL Serve Management Studio,
I got these error in ERROR.LOG file. Any help is really appreciated.
Thanks.
2006-09-21 12:48:21.53 Server Microsoft SQL Server 2005 -
9.00.2047.00 (Intel X86)
Apr 14 2006 01:12:25
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2006-09-21 12:48:21.54 Server (c) 2005 Microsoft Corporation.
2006-09-21 12:48:21.54 Server All rights reserved.
2006-09-21 12:48:21.54 Server Server process ID is 4948.
2006-09-21 12:48:21.54 Server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2006-09-21 12:48:21.54 Server This instance of SQL Server last
reported using a process ID of 4396 at 9/21/2006 1:05:02 AM (local)
9/21/2006 8:05:02 AM (UTC). This is an informational message only; no
user action is required.
2006-09-21 12:48:21.54 Server Registry startup parameters:
2006-09-21 12:48:21.59 Server -d C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\master.mdf
2006-09-21 12:48:21.59 Server -e C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2006-09-21 12:48:21.59 Server -l C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2006-09-21 12:48:21.64 Server SQL Server is starting at normal
priority base (=7). This is an informational message only. No user
action is required.
2006-09-21 12:48:21.64 Server Detected 2 CPUs. This is an
informational message; no user action is required.
2006-09-21 12:48:22.64 Server Using dynamic lock allocation.
Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per
node. This is an informational message only. No user action is
required.
2006-09-21 12:48:23.65 Server Attempting to initialize Microsoft
Distributed Transaction Coordinator (MS DTC). This is an informational
message only. No user action is required.
2006-09-21 12:48:24.23 Server The Microsoft Distributed
Transaction Coordinator (MS DTC) service could not be contacted. If
you would like distributed transaction functionality, please start this
service.
2006-09-21 12:48:24.48 Server Database mirroring has been enabled
on this instance of SQL Server.
2006-09-21 12:48:24.84 spid5s Starting up database 'master'.
2006-09-21 12:48:25.42 spid5s SQL Trace ID 1 was started by login
"sa".
2006-09-21 12:48:25.46 spid5s Starting up database
'mssqlsystemresource'.
2006-09-21 12:48:25.54 spid5s The resource database build version
is 9.00.2047. This is an informational message only. No user action is
required.
2006-09-21 12:48:25.98 spid5s Server name is 'BLAHBLAH'. This is
an informational message only. No user action is required.
2006-09-21 12:48:25.98 spid9s Starting up database 'model'.
2006-09-21 12:48:26.46 spid9s Clearing tempdb database.
2006-09-21 12:48:30.10 spid9s Starting up database 'tempdb'.
2006-09-21 12:48:30.54 spid12s The Service Broker protocol
transport is disabled or not configured.
2006-09-21 12:48:30.54 spid12s The Database Mirroring protocol
transport is disabled or not configured.
2006-09-21 12:48:31.12 spid12s Service Broker manager has started.
2006-09-21 12:48:31.39 Server A self-generated certificate was
successfully loaded for encryption.
2006-09-21 12:48:31.40 Server Error: 26055, Severity: 16, State:
1.
2006-09-21 12:48:31.40 Server The SQL Server failed to initialize
VIA support library [QLVipl.dll]. This normally indicates the VIA
support library does not exist or is corrupted. Please repair or
disable the VIA network protocol. Error: 0x7e.
2006-09-21 12:48:31.42 Server Error: 17182, Severity: 16, State:
1.
2006-09-21 12:48:31.42 Server TDSSNIClient initialization failed
with error 0x7e, status code 0x60.
2006-09-21 12:48:31.43 Server Error: 17182, Severity: 16, State:
1.
2006-09-21 12:48:31.43 Server TDSSNIClient initialization failed
with error 0x7e, status code 0x1.
2006-09-21 12:48:31.43 Server Error: 17826, Severity: 18, State:
3.
2006-09-21 12:48:31.43 Server Could not start the network library
because of an internal error in the network library. To determine the
cause, review the errors immediately preceding this one in the error
log.
2006-09-21 12:48:31.43 Server Error: 17120, Severity: 16, State:
1.
2006-09-21 12:48:31.43 Server SQL Server could not spawn FRunCM
thread. Check the SQL Server error log and the Windows event logs for
information about possible related problems.I googled for TDSSNIClient and had several hits, for instance
http://blogs.msdn.com/sql_protocols/archive/2005/10/31/487090.aspx.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"sara" <sarasara82@.gmail.com> wrote in message
news:1158882314.356874.272310@.h48g2000cwc.googlegroups.com...
> Hi All,
> I can not connect to sql serve 2005 using SQL Serve Management Studio,
> I got these error in ERROR.LOG file. Any help is really appreciated.
> Thanks.
> 2006-09-21 12:48:21.53 Server Microsoft SQL Server 2005 -
> 9.00.2047.00 (Intel X86)
> Apr 14 2006 01:12:25
> Copyright (c) 1988-2005 Microsoft Corporation
> Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
> 2006-09-21 12:48:21.54 Server (c) 2005 Microsoft Corporation.
> 2006-09-21 12:48:21.54 Server All rights reserved.
> 2006-09-21 12:48:21.54 Server Server process ID is 4948.
> 2006-09-21 12:48:21.54 Server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
> 2006-09-21 12:48:21.54 Server This instance of SQL Server last
> reported using a process ID of 4396 at 9/21/2006 1:05:02 AM (local)
> 9/21/2006 8:05:02 AM (UTC). This is an informational message only; no
> user action is required.
> 2006-09-21 12:48:21.54 Server Registry startup parameters:
> 2006-09-21 12:48:21.59 Server -d C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\DATA\master.mdf
> 2006-09-21 12:48:21.59 Server -e C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\LOG\ERRORLOG
> 2006-09-21 12:48:21.59 Server -l C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
> 2006-09-21 12:48:21.64 Server SQL Server is starting at normal
> priority base (=7). This is an informational message only. No user
> action is required.
> 2006-09-21 12:48:21.64 Server Detected 2 CPUs. This is an
> informational message; no user action is required.
> 2006-09-21 12:48:22.64 Server Using dynamic lock allocation.
> Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per
> node. This is an informational message only. No user action is
> required.
> 2006-09-21 12:48:23.65 Server Attempting to initialize Microsoft
> Distributed Transaction Coordinator (MS DTC). This is an informational
> message only. No user action is required.
> 2006-09-21 12:48:24.23 Server The Microsoft Distributed
> Transaction Coordinator (MS DTC) service could not be contacted. If
> you would like distributed transaction functionality, please start this
> service.
> 2006-09-21 12:48:24.48 Server Database mirroring has been enabled
> on this instance of SQL Server.
> 2006-09-21 12:48:24.84 spid5s Starting up database 'master'.
> 2006-09-21 12:48:25.42 spid5s SQL Trace ID 1 was started by login
> "sa".
> 2006-09-21 12:48:25.46 spid5s Starting up database
> 'mssqlsystemresource'.
> 2006-09-21 12:48:25.54 spid5s The resource database build version
> is 9.00.2047. This is an informational message only. No user action is
> required.
> 2006-09-21 12:48:25.98 spid5s Server name is 'BLAHBLAH'. This is
> an informational message only. No user action is required.
> 2006-09-21 12:48:25.98 spid9s Starting up database 'model'.
> 2006-09-21 12:48:26.46 spid9s Clearing tempdb database.
> 2006-09-21 12:48:30.10 spid9s Starting up database 'tempdb'.
> 2006-09-21 12:48:30.54 spid12s The Service Broker protocol
> transport is disabled or not configured.
> 2006-09-21 12:48:30.54 spid12s The Database Mirroring protocol
> transport is disabled or not configured.
> 2006-09-21 12:48:31.12 spid12s Service Broker manager has started.
> 2006-09-21 12:48:31.39 Server A self-generated certificate was
> successfully loaded for encryption.
> 2006-09-21 12:48:31.40 Server Error: 26055, Severity: 16, State:
> 1.
> 2006-09-21 12:48:31.40 Server The SQL Server failed to initialize
> VIA support library [QLVipl.dll]. This normally indicates the VIA
> support library does not exist or is corrupted. Please repair or
> disable the VIA network protocol. Error: 0x7e.
> 2006-09-21 12:48:31.42 Server Error: 17182, Severity: 16, State:
> 1.
> 2006-09-21 12:48:31.42 Server TDSSNIClient initialization failed
> with error 0x7e, status code 0x60.
> 2006-09-21 12:48:31.43 Server Error: 17182, Severity: 16, State:
> 1.
> 2006-09-21 12:48:31.43 Server TDSSNIClient initialization failed
> with error 0x7e, status code 0x1.
> 2006-09-21 12:48:31.43 Server Error: 17826, Severity: 18, State:
> 3.
> 2006-09-21 12:48:31.43 Server Could not start the network library
> because of an internal error in the network library. To determine the
> cause, review the errors immediately preceding this one in the error
> log.
> 2006-09-21 12:48:31.43 Server Error: 17120, Severity: 16, State:
> 1.
> 2006-09-21 12:48:31.43 Server SQL Server could not spawn FRunCM
> thread. Check the SQL Server error log and the Windows event logs for
> information about possible related problems.
>

Sunday, March 25, 2012

connection problem

One customer reported they were having problem with their Access database
that is
linked to our SQL Server. They had to relink the tables every 30 minutes
when working on the db. Where should I look on the SQL server to determine
if this is SQL server related or network related?
Thanks,
Bing"bing" <bing@.discussions.microsoft.com> wrote in message
news:6C9ADFB9-51B5-451C-A921-540624570C1F@.microsoft.com...
> One customer reported they were having problem with their Access database
> that is
> linked to our SQL Server. They had to relink the tables every 30 minutes
> when working on the db. Where should I look on the SQL server to
determine
> if this is SQL server related or network related?
What problem were they having? And, what versions of products are being
used? More information is better in this case ;)
Steve|||This is SQL server 2000 with SP3a installed on Windows 2003.
I just checked the Application logs in the Even Viewer on the SQL server and
found the following errors repeated every 30 minutes that seems to match the
problem symtom the customer is having. I've searched on the web and looks
like the problem has something to do with group policy.
Could these errors be the cause of the problem? Are they that bad that can
break connection between the client and the server?
==========Type Date Time Source Category Event User Computer
Error 8/24/2004 3:54:12 PM Userenv None 1085 SYSTEM pc100
Error 8/24/2004 3:54:12 PM Userenv None 1091 SYSTEM pc100
==========
Would anybody give any insight on this? Thanks much in advance.
Bing
"Steve Thompson" wrote:
> "bing" <bing@.discussions.microsoft.com> wrote in message
> news:6C9ADFB9-51B5-451C-A921-540624570C1F@.microsoft.com...
> > One customer reported they were having problem with their Access database
> > that is
> > linked to our SQL Server. They had to relink the tables every 30 minutes
> > when working on the db. Where should I look on the SQL server to
> determine
> > if this is SQL server related or network related?
> What problem were they having? And, what versions of products are being
> used? More information is better in this case ;)
> Steve
>
>|||According to the following article those errors occur if you are enforcing
IPSec. And, there is a hotfix for this issue -- not sure if it's related to
your linked tables issue but it's a start.
http://support.microsoft.com/default.aspx?scid=kb;en-us;823608&Product=winsvr2003
Steve
"bing" <bing@.discussions.microsoft.com> wrote in message
news:F749D976-A9F3-4E64-913C-92F38E020F5C@.microsoft.com...
> This is SQL server 2000 with SP3a installed on Windows 2003.
> I just checked the Application logs in the Even Viewer on the SQL server
and
> found the following errors repeated every 30 minutes that seems to match
the
> problem symtom the customer is having. I've searched on the web and
looks
> like the problem has something to do with group policy.
> Could these errors be the cause of the problem? Are they that bad that
can
> break connection between the client and the server?
> ==========> Type Date Time Source Category Event User Computer
> Error 8/24/2004 3:54:12 PM Userenv None 1085 SYSTEM pc100
> Error 8/24/2004 3:54:12 PM Userenv None 1091 SYSTEM pc100
> ==========> Would anybody give any insight on this? Thanks much in advance.
> Bing
> "Steve Thompson" wrote:
> > "bing" <bing@.discussions.microsoft.com> wrote in message
> > news:6C9ADFB9-51B5-451C-A921-540624570C1F@.microsoft.com...
> > > One customer reported they were having problem with their Access
database
> > > that is
> > > linked to our SQL Server. They had to relink the tables every 30
minutes
> > > when working on the db. Where should I look on the SQL server to
> > determine
> > > if this is SQL server related or network related?
> >
> > What problem were they having? And, what versions of products are being
> > used? More information is better in this case ;)
> >
> > Steve
> >
> >
> >|||I thought hotfixes for specific issues were free of charge? If they are
telling you that you need to pay for this -- get back to me and we'll figure
out a way to get it to you.
Steve
"bing" <bing@.discussions.microsoft.com> wrote in message
news:1CC2B1D1-7950-4E8D-9CB9-B1B44871F8FE@.microsoft.com...
> Ok, I'm stuck on get Microsoft Product Support Services. After taking
some
> time finding the product ID of the SQL server, MS said this ID cannot get
> no-charge support. Does that mean we have to pay to get this hotfix?
> Bing
> "Steve Thompson" wrote:
> > According to the following article those errors occur if you are
enforcing
> > IPSec. And, there is a hotfix for this issue -- not sure if it's related
to
> > your linked tables issue but it's a start.
> >
http://support.microsoft.com/default.aspx?scid=kb;en-us;823608&Product=winsvr2003
> >
> > Steve
> > "bing" <bing@.discussions.microsoft.com> wrote in message
> > news:F749D976-A9F3-4E64-913C-92F38E020F5C@.microsoft.com...
> > > This is SQL server 2000 with SP3a installed on Windows 2003.
> > >
> > > I just checked the Application logs in the Even Viewer on the SQL
server
> > and
> > > found the following errors repeated every 30 minutes that seems to
match
> > the
> > > problem symtom the customer is having. I've searched on the web
and
> > looks
> > > like the problem has something to do with group policy.
> > >
> > > Could these errors be the cause of the problem? Are they that bad
that
> > can
> > > break connection between the client and the server?
> > >
> > > ==========> > > Type Date Time Source Category Event User Computer
> > >
> > > Error 8/24/2004 3:54:12 PM Userenv None 1085 SYSTEM pc100
> > > Error 8/24/2004 3:54:12 PM Userenv None 1091 SYSTEM pc100
> > > ==========> > >
> > > Would anybody give any insight on this? Thanks much in advance.
> > >
> > > Bing
> > >
> > > "Steve Thompson" wrote:
> > >
> > > > "bing" <bing@.discussions.microsoft.com> wrote in message
> > > > news:6C9ADFB9-51B5-451C-A921-540624570C1F@.microsoft.com...
> > > > > One customer reported they were having problem with their Access
> > database
> > > > > that is
> > > > > linked to our SQL Server. They had to relink the tables every 30
> > minutes
> > > > > when working on the db. Where should I look on the SQL server to
> > > > determine
> > > > > if this is SQL server related or network related?
> > > >
> > > > What problem were they having? And, what versions of products are
being
> > > > used? More information is better in this case ;)
> > > >
> > > > Steve
> > > >
> > > >
> > > >
> >
> >
> >|||My suggestion would be call into the queue, request the specific hotfix
noted in 823608, tell the support person that you need that specific hotfix
to solve your issue.
There is a note on that page:
"Note In special cases, charges that are ordinarily incurred for support
calls may be canceled if a Microsoft Support Professional determines that a
specific update will resolve your problem. "
As long as you do not bring up any other issue as part of that support call
it appears you would qualify.
Steve
"bing" <bing@.discussions.microsoft.com> wrote in message
news:28E58896-12A6-4A8E-ABED-08BD1FCC7856@.microsoft.com...
> Thanks much, Steve, for getting back to this track. It's not any person
in
> MS who told me that. Following the link provided in the KB article you
> pointed out, I got on the support site. Next entered my personal passport
> email and password, selected product SQL server, selected No-Charge
Support,
> input the Product ID number for our SQL Server. Then I got the following
> message back:
> Products purchased under a Select License Agreement or Software Assurance
> Home Use Program are not eligible for no-charge support. You may go back
and
> choose another support option or enter another Product ID number.
> I did not know how I should proceed from there. Any advices would be
> greatly appreciated. A couple of more questions. The KB article with the
> title 'Event ID 1091 and Event ID 1085 Appear in the Application Event
Log'
> says:
> " if you are not severely affected by this problem, Microsoft recommends
> that you wait for the next Windows Server 2003 service pack that contains
> this fix."
> Is there any more detailed information that tells what bad impacts these
> events could cause? I can not fully get what 'severely affected' really
> means. Any time table for when the next Windows Server 2003 service pack
> that contains this fix will be released?
> Bing
> "Steve Thompson" wrote:
> > I thought hotfixes for specific issues were free of charge? If they are
> > telling you that you need to pay for this -- get back to me and we'll
figure
> > out a way to get it to you.
> >
> > Steve
> >
> > "bing" <bing@.discussions.microsoft.com> wrote in message
> > news:1CC2B1D1-7950-4E8D-9CB9-B1B44871F8FE@.microsoft.com...
> > > Ok, I'm stuck on get Microsoft Product Support Services. After taking
> > some
> > > time finding the product ID of the SQL server, MS said this ID cannot
get
> > > no-charge support. Does that mean we have to pay to get this hotfix?
> > >
> > > Bing
> > >
> > > "Steve Thompson" wrote:
> > >
> > > > According to the following article those errors occur if you are
> > enforcing
> > > > IPSec. And, there is a hotfix for this issue -- not sure if it's
related
> > to
> > > > your linked tables issue but it's a start.
> > > >
> >
http://support.microsoft.com/default.aspx?scid=kb;en-us;823608&Product=winsvr2003
> > > >
> > > > Steve
> > > > "bing" <bing@.discussions.microsoft.com> wrote in message
> > > > news:F749D976-A9F3-4E64-913C-92F38E020F5C@.microsoft.com...
> > > > > This is SQL server 2000 with SP3a installed on Windows 2003.
> > > > >
> > > > > I just checked the Application logs in the Even Viewer on the SQL
> > server
> > > > and
> > > > > found the following errors repeated every 30 minutes that seems to
> > match
> > > > the
> > > > > problem symtom the customer is having. I've searched on the
web
> > and
> > > > looks
> > > > > like the problem has something to do with group policy.
> > > > >
> > > > > Could these errors be the cause of the problem? Are they that bad
> > that
> > > > can
> > > > > break connection between the client and the server?
> > > > >
> > > > > ==========> > > > > Type Date Time Source Category Event User
Computer
> > > > >
> > > > > Error 8/24/2004 3:54:12 PM Userenv None 1085 SYSTEM pc100
> > > > > Error 8/24/2004 3:54:12 PM Userenv None 1091 SYSTEM pc100
> > > > > ==========> > > > >
> > > > > Would anybody give any insight on this? Thanks much in advance.
> > > > >
> > > > > Bing
> > > > >
> > > > > "Steve Thompson" wrote:
> > > > >
> > > > > > "bing" <bing@.discussions.microsoft.com> wrote in message
> > > > > > news:6C9ADFB9-51B5-451C-A921-540624570C1F@.microsoft.com...
> > > > > > > One customer reported they were having problem with their
Access
> > > > database
> > > > > > > that is
> > > > > > > linked to our SQL Server. They had to relink the tables every
30
> > > > minutes
> > > > > > > when working on the db. Where should I look on the SQL server
to
> > > > > > determine
> > > > > > > if this is SQL server related or network related?
> > > > > >
> > > > > > What problem were they having? And, what versions of products
are
> > being
> > > > > > used? More information is better in this case ;)
> > > > > >
> > > > > > Steve
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||Hi Bing,
Sorry for the delay in responding -- comments in-line.
Steve
"bing" <bing@.discussions.microsoft.com> wrote in message
news:28E58896-12A6-4A8E-ABED-08BD1FCC7856@.microsoft.com...
> Thanks much, Steve, for getting back to this track. It's not any person
in
> MS who told me that. Following the link provided in the KB article you
> pointed out, I got on the support site. Next entered my personal passport
> email and password, selected product SQL server, selected No-Charge
Support,
> input the Product ID number for our SQL Server. Then I got the following
> message back:
> Products purchased under a Select License Agreement or Software Assurance
> Home Use Program are not eligible for no-charge support. You may go back
and
> choose another support option or enter another Product ID number.
Please respond with a valid email address and I'll see if I can get you a
copy (no promises and no other requests!).
> I did not know how I should proceed from there. Any advices would be
> greatly appreciated. A couple of more questions. The KB article with the
> title 'Event ID 1091 and Event ID 1085 Appear in the Application Event
Log'
> says:
> " if you are not severely affected by this problem, Microsoft recommends
> that you wait for the next Windows Server 2003 service pack that contains
> this fix."
> Is there any more detailed information that tells what bad impacts these
> events could cause?
That disclaimer is actually Microsoft normal -- they are stating that a
hotifx has not had the extensive regression testing that a service pack has
experienced. While it usually fixes the specific problem as advertised, they
cannot know of any and all colateral side effects that may be introduced. My
methodology has been, test in a lab, if it works, roll it out to QA then
production..
> I can not fully get what 'severely affected' really
> means.
Again, disclaimer time -- what is your threshold of pain ;) if you cannot
live without this hotfix then apply it.
>Any time table for when the next Windows Server 2003 service pack
> that contains this fix will be released?
Sources indicate that Windows Server 2003 SP1 will be available early next
year. Release dates are subject to change, etc, etc, etc.
Steve
> Bing
> "Steve Thompson" wrote:
> > I thought hotfixes for specific issues were free of charge? If they are
> > telling you that you need to pay for this -- get back to me and we'll
figure
> > out a way to get it to you.
> >
> > Steve
> >
> > "bing" <bing@.discussions.microsoft.com> wrote in message
> > news:1CC2B1D1-7950-4E8D-9CB9-B1B44871F8FE@.microsoft.com...
> > > Ok, I'm stuck on get Microsoft Product Support Services. After taking
> > some
> > > time finding the product ID of the SQL server, MS said this ID cannot
get
> > > no-charge support. Does that mean we have to pay to get this hotfix?
> > >
> > > Bing
> > >
> > > "Steve Thompson" wrote:
> > >
> > > > According to the following article those errors occur if you are
> > enforcing
> > > > IPSec. And, there is a hotfix for this issue -- not sure if it's
related
> > to
> > > > your linked tables issue but it's a start.
> > > >
> >
http://support.microsoft.com/default.aspx?scid=kb;en-us;823608&Product=winsvr2003
> > > >
> > > > Steve
> > > > "bing" <bing@.discussions.microsoft.com> wrote in message
> > > > news:F749D976-A9F3-4E64-913C-92F38E020F5C@.microsoft.com...
> > > > > This is SQL server 2000 with SP3a installed on Windows 2003.
> > > > >
> > > > > I just checked the Application logs in the Even Viewer on the SQL
> > server
> > > > and
> > > > > found the following errors repeated every 30 minutes that seems to
> > match
> > > > the
> > > > > problem symtom the customer is having. I've searched on the
web
> > and
> > > > looks
> > > > > like the problem has something to do with group policy.
> > > > >
> > > > > Could these errors be the cause of the problem? Are they that bad
> > that
> > > > can
> > > > > break connection between the client and the server?
> > > > >
> > > > > ==========> > > > > Type Date Time Source Category Event User
Computer
> > > > >
> > > > > Error 8/24/2004 3:54:12 PM Userenv None 1085 SYSTEM pc100
> > > > > Error 8/24/2004 3:54:12 PM Userenv None 1091 SYSTEM pc100
> > > > > ==========> > > > >
> > > > > Would anybody give any insight on this? Thanks much in advance.
> > > > >
> > > > > Bing
> > > > >
> > > > > "Steve Thompson" wrote:
> > > > >
> > > > > > "bing" <bing@.discussions.microsoft.com> wrote in message
> > > > > > news:6C9ADFB9-51B5-451C-A921-540624570C1F@.microsoft.com...
> > > > > > > One customer reported they were having problem with their
Access
> > > > database
> > > > > > > that is
> > > > > > > linked to our SQL Server. They had to relink the tables every
30
> > > > minutes
> > > > > > > when working on the db. Where should I look on the SQL server
to
> > > > > > determine
> > > > > > > if this is SQL server related or network related?
> > > > > >
> > > > > > What problem were they having? And, what versions of products
are
> > being
> > > > > > used? More information is better in this case ;)
> > > > > >
> > > > > > Steve
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||Bing,
Check your mail.
Steve
"bing" <bing@.discussions.microsoft.com> wrote in message
news:C9D33B0B-09F9-4F4E-BB1C-160AA055A735@.microsoft.com...
> Thanks Steve for all the help. The valid email address is
bdu@.iastate.edu.
> Bing
> "Steve Thompson" wrote:
> > Hi Bing,
> >
> > Sorry for the delay in responding -- comments in-line.
> >
> > Steve
> >
> > "bing" <bing@.discussions.microsoft.com> wrote in message
> > news:28E58896-12A6-4A8E-ABED-08BD1FCC7856@.microsoft.com...
> > > Thanks much, Steve, for getting back to this track. It's not any
person
> > in
> > > MS who told me that. Following the link provided in the KB article
you
> > > pointed out, I got on the support site. Next entered my personal
passport
> > > email and password, selected product SQL server, selected No-Charge
> > Support,
> > > input the Product ID number for our SQL Server. Then I got the
following
> > > message back:
> > >
> > > Products purchased under a Select License Agreement or Software
Assurance
> > > Home Use Program are not eligible for no-charge support. You may go
back
> > and
> > > choose another support option or enter another Product ID number.
> >
> > Please respond with a valid email address and I'll see if I can get you
a
> > copy (no promises and no other requests!).
> >
> > > I did not know how I should proceed from there. Any advices would be
> > > greatly appreciated. A couple of more questions. The KB article with
the
> > > title 'Event ID 1091 and Event ID 1085 Appear in the Application Event
> > Log'
> > > says:
> > >
> > > " if you are not severely affected by this problem, Microsoft
recommends
> > > that you wait for the next Windows Server 2003 service pack that
contains
> > > this fix."
> > >
> > > Is there any more detailed information that tells what bad impacts
these
> > > events could cause?
> >
> > That disclaimer is actually Microsoft normal -- they are stating that a
> > hotifx has not had the extensive regression testing that a service pack
has
> > experienced. While it usually fixes the specific problem as advertised,
they
> > cannot know of any and all colateral side effects that may be
introduced. My
> > methodology has been, test in a lab, if it works, roll it out to QA then
> > production..
> >
> > > I can not fully get what 'severely affected' really
> > > means.
> >
> > Again, disclaimer time -- what is your threshold of pain ;) if you
cannot
> > live without this hotfix then apply it.
> >
> > >Any time table for when the next Windows Server 2003 service pack
> > > that contains this fix will be released?
> >
> > Sources indicate that Windows Server 2003 SP1 will be available early
next
> > year. Release dates are subject to change, etc, etc, etc.
> >
> > Steve
> >
> > > Bing
> > >
> > > "Steve Thompson" wrote:
> > >
> > > > I thought hotfixes for specific issues were free of charge? If they
are
> > > > telling you that you need to pay for this -- get back to me and
we'll
> > figure
> > > > out a way to get it to you.
> > > >
> > > > Steve
> > > >
> > > > "bing" <bing@.discussions.microsoft.com> wrote in message
> > > > news:1CC2B1D1-7950-4E8D-9CB9-B1B44871F8FE@.microsoft.com...
> > > > > Ok, I'm stuck on get Microsoft Product Support Services. After
taking
> > > > some
> > > > > time finding the product ID of the SQL server, MS said this ID
cannot
> > get
> > > > > no-charge support. Does that mean we have to pay to get this
hotfix?
> > > > >
> > > > > Bing
> > > > >
> > > > > "Steve Thompson" wrote:
> > > > >
> > > > > > According to the following article those errors occur if you are
> > > > enforcing
> > > > > > IPSec. And, there is a hotfix for this issue -- not sure if it's
> > related
> > > > to
> > > > > > your linked tables issue but it's a start.
> > > > > >
> > > >
> >
http://support.microsoft.com/default.aspx?scid=kb;en-us;823608&Product=winsvr2003
> > > > > >
> > > > > > Steve
> > > > > > "bing" <bing@.discussions.microsoft.com> wrote in message
> > > > > > news:F749D976-A9F3-4E64-913C-92F38E020F5C@.microsoft.com...
> > > > > > > This is SQL server 2000 with SP3a installed on Windows 2003.
> > > > > > >
> > > > > > > I just checked the Application logs in the Even Viewer on the
SQL
> > > > server
> > > > > > and
> > > > > > > found the following errors repeated every 30 minutes that
seems to
> > > > match
> > > > > > the
> > > > > > > problem symtom the customer is having. I've searched on
the
> > web
> > > > and
> > > > > > looks
> > > > > > > like the problem has something to do with group policy.
> > > > > > >
> > > > > > > Could these errors be the cause of the problem? Are they that
bad
> > > > that
> > > > > > can
> > > > > > > break connection between the client and the server?
> > > > > > >
> > > > > > > ==========> > > > > > > Type Date Time Source Category Event User
> > Computer
> > > > > > >
> > > > > > > Error 8/24/2004 3:54:12 PM Userenv None 1085 SYSTEM
pc100
> > > > > > > Error 8/24/2004 3:54:12 PM Userenv None 1091 SYSTEM
pc100
> > > > > > > ==========> > > > > > >
> > > > > > > Would anybody give any insight on this? Thanks much in
advance.
> > > > > > >
> > > > > > > Bing
> > > > > > >
> > > > > > > "Steve Thompson" wrote:
> > > > > > >
> > > > > > > > "bing" <bing@.discussions.microsoft.com> wrote in message
> > > > > > > > news:6C9ADFB9-51B5-451C-A921-540624570C1F@.microsoft.com...
> > > > > > > > > One customer reported they were having problem with their
> > Access
> > > > > > database
> > > > > > > > > that is
> > > > > > > > > linked to our SQL Server. They had to relink the tables
every
> > 30
> > > > > > minutes
> > > > > > > > > when working on the db. Where should I look on the SQL
server
> > to
> > > > > > > > determine
> > > > > > > > > if this is SQL server related or network related?
> > > > > > > >
> > > > > > > > What problem were they having? And, what versions of
products
> > are
> > > > being
> > > > > > > > used? More information is better in this case ;)
> > > > > > > >
> > > > > > > > Steve
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

connection problem

I am a newbie to SQL server. I have installed SQL server on my PC. I have created a local server on my machine. When i go to the SQL server wizard to register my server and it gives me the option to connect i am getting the message: SQL server does not exist or access denied. Now i was told that this may be due to my firewall. I have turned these off..and am still getting the message.
Please help
JohnHi John,
What was the authentication mode that you selected while installing the SQL
Server ?
If you have created in Mixed mode, What is the SA Password ?
Is it blank ?
Did you create a named instance or is it the default instance ?
If you have created a named instance, what is the name that you
have assigned to this new instance ?
Just a step by step info, in case you have missed one.
1. "Select a Server" Step
If your instllation is the default installation, then
type your computer name for the "Available Servers" and click on
Add.
If your installation is the Named instance, then
type the server name as "Computername\InstanceName" for the
"Available Servers" and click on ADD.
2. "Select an Authentication Mode" step
If you have selected Mixed Mode authentication, then select
"The SQL Server Login information that was assigned to me by
the system administrator"
3. If you select SQL Server login, you get this additional step "Select
Connection Option"
select first option "Login Automatically using my SQL Server account
information"
Login Name : SA
Password : <The password that you have set> or leave it
blank, if you had set it blank.
4. "Select SQL Server Group" step
select "Add the SQL Server(s) to an existing SQL Server Group".
5. Click on Finish, to get connected to the SQL Server.
With this simple steps you should be able to register the SQL Server in
Enterprise Manager.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.

Connection Problem

I created a package with two oledb connections in the connection manager....which was running perfectly...later i deleted these connections and added two new connections....and applied these to task with the new connection..

Now i run the package i come up with the following error...connection not found

Error 1 Error loading test.dtsx: The connection "SQL-DEV.sql_dev" is not found. This error is thrown by Connections collection when the specific connection element is not found. c:\documents and settings\myname\desktop\integration services project\ssis\test.dtsx 1 1

when i double click the error it goes to xml code...i dont know what need to be done...please help

Did you name the "new" connections the same as the old connections?|||No i didnt name them with the same name as the old once but the New connections are just the same as old connections...selecting server and database..|||Is "SQL-DEV.sql_dev" the name of a new connection or one of the ones you deleted?|||

Hi Sureshv,

The problem is the Connection Managers, for whatever reason, were not completely deleted. Their metadata is still stored inside the XML source for the SSIS files.

Naming the new Connection Managers the same as the old Connection Managers will not impact this error - Connection Managers are identified by GUIDs in SSIS. If you can identify the GUID of the deleted Connection Managers (perhaps by process of elimination), and comment them out inside the metadata, the package will stop throwing the error.

Hope this helps,
Andy

|||Andy,
ALL GUI screens represent a connection manager by its name, not GUID. This is precisely why I asked the question that I did. I imagined a scenario where the metadata was not cleaned up properly and when Sureshv picked the connection manager [name] in the drop down box, it was associated with a [now] defunct GUID, hence the resulting error.

In the end I think we can agree the likely culprit is bad metadata.|||

Hi Phil,

Thanks. I've seen some tasks respond differently to this scenario. Some of them pick up the changes automatically and some don't. I've also seen metadata corruption make this completely unpredicatable.

Yep - we agree this is the culprit. It's no fun to clean up a large package with corrupt metadat either - good luck Sureshv.

Andy

|||

In general when you delete a connection manager that is being used by a task; that task keeps pointing to the deleted connection manager GUID; untill you open the task and chose a diffrent one.

To the Original poster, make sure you revist all the tasks that were using those connection managers and refresh the connection metadata. If the package has logging enable and it was using one of the deleted CM; you have to refresh it as well.

|||i dont find the old connection name with in connection managers in the xml...So what do i do? i am afraid i will break my package...any more solutions?|||Did you check and correct the package logging?|||i did not set any package logging for this package..sql sql

connection problem

hy,

I have deployed my package to an microsoft sql 2005 server, this is error free. but i can't connect to the server it gives an error "access is denied".

i have tried looking at the rights i have and normally it should do it.

if anybody has an idea what's the problem might be, shoot.
thanks in front,

jens

I have tried the advise that was posted elsewhere (http://sqljunkies.com/WebLog/knight_reign/archive/2006/01/05/17769.aspx) gave myself all rights. still doesn't work.

Please if you have the slightest idea. post it. much oblidged

Jens

|||

What kind of server are you trying to connect to? SQL Server? SSIS Server? etc...

From where are you trying to connect to it? From BIDS? From SSMS? From a remote app? From the command-line? etc...

How are you conencting to it? SQL auth? Windows auth?

Provide more information and you might get more answers.

-Jamie

connection problem

I want to connect a VB6 application to a sql express 2005 database. My database is on a server with windows 2003 server and my application is running on a windows XP machine. I try to use ado and almost all connection string i saw on internet, the best i got is the error:

connection failed

SQLState '01000'

SQL Server error: 53

SQL Server does not exist or access denied.

even if i use the same server name and authentification as in the microsoft sql server management studio express.

This is my code:

Dim cn As ADODB.Connection
Set cn = New ADODB.Connection

cn.Properties("Prompt") = adPromptAlways
cn.Open "Driver={SQL Server};Server=server\sqlexpress;DataBase=master;"

thanks

Ben

Hi,

did you try to specify explictly the authentication mode ?

Trusted connection:

"Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connection=yes;"

(From www.connectionstrings.com)

Otherwise you could also try to use the ADO connectionstring rather than the ODBC one.

Make sure that you configured remote connections for the Server to connect to.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||

thanks for your answer.

I try to run the same code on my server (that host the db)... and it work . So, my problem is with the remote part. My server and client machine are both on a lan, without a domain controler. I can manage my server throught my client computer using remote desktop so it's not a lan problem.

i try both Trusted_Connection and not .

I use that configuration in connection string : Server = [server_name]\sqlexpress

>Make sure that you configured remote connections for the Server to connect to.

I enabled all protocols in sql server 2005 Network configuration, something else to do ?

Thanks

|||

SQL Express has remote connections turned off by default; it sounds like you need to enable them. Check out the BLOG posting on this topic at http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Regards,

Mike Wachal - SQL Express team

|||

For those of you who want the complete solution :

Using Ado in VB6

The code :

Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
cn.Properties("Prompt") = adPromptAlways
cn.Open "Driver={SQL Server};Server=server\sqlexpress,2301;DataBase=master;uid=dbuser;password=pass;databasename=master;"

'2301 is the port number (TCP port, explain later)

Setting on server :

go to:

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx?notification_id=1414271&message_id=1414271

and i do step 1, 2 OPTION A

You need to create (or use one that is already create) a user that has enought privilege on the table and database you want to use. Use SQL server management studio.

Now you can use that solution in your VB client program to acess remotely your database server.

Thanks a lot Mike and Jens ! and all SQL Express Team

|||for all fellow javascript, j#, c#, c++ programmers out there: remember vb "server\sqlexpress" = "server\\sqlexpress" in our languages!

connection problem

connection failed

SQLState '01000'

SQL Server error: 53

SQL Server does not exist or access denied.

even if i use the same server name and authentification as in the microsoft sql server management studio express.

This is my code:

Dim cn As ADODB.Connection
Set cn = New ADODB.Connection

cn.Properties("Prompt") = adPromptAlways
cn.Open "Driver={SQL Server};Server=server\sqlexpress;DataBase=master;"

thanks

Ben

Hi,

did you try to specify explictly the authentication mode ?

Trusted connection:

"Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connection=yes;"

(From www.connectionstrings.com)

Otherwise you could also try to use the ADO connectionstring rather than the ODBC one.

Make sure that you configured remote connections for the Server to connect to.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||

thanks for your answer.

i try both Trusted_Connection and not .

I use that configuration in connection string : Server = [server_name]\sqlexpress

>Make sure that you configured remote connections for the Server to connect to.

I enabled all protocols in sql server 2005 Network configuration, something else to do ?

Thanks

|||

Regards,

Mike Wachal - SQL Express team

|||

For those of you who want the complete solution :

Using Ado in VB6

The code :

'2301 is the port number (TCP port, explain later)

Setting on server :

go to:

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx?notification_id=1414271&message_id=1414271

and i do step 1, 2 OPTION A

You need to create (or use one that is already create) a user that has enought privilege on the table and database you want to use. Use SQL server management studio.

Now you can use that solution in your VB client program to acess remotely your database server.

Thanks a lot Mike and Jens ! and all SQL Express Team

|||for all fellow javascript, j#, c#, c++ programmers out there: remember vb "server\sqlexpress" = "server\\sqlexpress" in our languages!

Connection problem

Strange database problem.
I have 2 servers one running as webserver and the other as Database server running MSSQL 2000 SP3.
They are connected i 2 ways. Through a public net using static IP and through a direct cable using another IP.

My problem is that I cannot connect to or from the database through the crossed cable (I run a DTS which imports a zipped access file from an FTP account on the webserver).
Running through the public net works fine but not through the crossed/direct cable.
All other connecting (ping, filesharing, FTP not through DTS, etc) works fine through that cable but ODBC connections from the webserver don't and neither does DTS access from the database server.
Does anyone have a clue.I assume there is a different IP associated with the crossed-cable connection. Configure your ODBC to use that IP address instead of the server name.|||That's what I couldn't do. However everything worked out after restarting the webbserver. Seems like it was just a glitch.sql sql

Connection problem

Hello!
Recently i have found SQLAPI++ library and it convinced me.
BUT i have some problems to connect to the SQL Server.
My connection string looks like that:
con.Connect(
"MOON", // database name
"abc", // user name
"abc", // password
SA_SQLServer_Client);

I always receive this message trying to connect:
[DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access denied

or with this connectioj string

con.Connect(
"MOON@.myClient", // database name
"abc", // user name
"abc", // password
SA_SQLServer_Client);

my authication seems to be wrong!

Is that a sql server configuration problem? I use windows authication to connect to the database server.

Any hints are welcome

Thanks

StefanWhat language are you using to program ? The authentification method could be your problem. Have you tried to enable sql server authetification and adding the userid abc and password abc ? Also, check out the connection method parameters - there should be a parameter that allows you to choose authentification method.|||Originally posted by rnealejr
What language are you using to program ? The authentification method could be your problem. Have you tried to enable sql server authetification and adding the userid abc and password abc ? Also, check out the connection method parameters - there should be a parameter that allows you to choose authentification method.

I use C++ with the SQLAPI++ Library!
I found out how it does it work. The userID and the password string have to be empty! Too easy
Thanks
Stefan

Connection Problem

Hi

I've got a small problem and i can't figure it out. I can connect successfully to the Microsoft SQL Server "Beauty" (get also nonzero for successfull connection). If i run the application (see code below). I get following Error Message "Illegal Objectname 'TestTabelle' ". I double checked the SQL statement and it should be correct. Even the spelling of TestTabelle is right. For testing purposes I've also included 5-6 data records in the tabel.

I try to connect via ODBC. I've created the database with MS SQL Enterprise Manager. Right Click -> Create New Database. I called it "Test" and created in "Test" a new Table, which is called "TestTabelle".

I found information how i can connect to a ms sql server "Beauty", i've also found how i can connect to a table, BUT where is the information which Database ?`in my case it should be Test.

Anyone can help ?
Thank you

{
CDBVariant value;
char sql_statement [2048] = "";

//CDatabase object "db" created to connect database
CDatabase db;
db.OpenEx(_T("DSN=Beauty;UID=Administrator"), CDatabase::noOdbcDialog);

//CRecordset object "rs" created to access and manipulate database records.
CRecordset rs(&db);
strcpy(sql_statement,_T("SELECT * FROM TestTabelle"));
rs.Open(CRecordset::forwardOnly,sql_statement);

//Get quantity from Database
int n = rs.GetODBCFieldCount( );
while(!rs.IsEOF())
{
for( int i = 0; i < n; i++ )
{
rs.GetFieldValue("index",value);
m_Buy_List.InsertItem(i,LPCTSTR(value.m_pstring));

rs.GetFieldValue("product",value);
m_Buy_List.SetItemText(i,2,LPCTSTR(value.m_pstring ));

rs.GetFieldValue("price",value);
m_Buy_List.SetItemText(i,3,LPCTSTR(value.m_pstring ));
}
rs.MoveNext( );
}

//Close records access.
rs.Close( );

//Close database connection.
db.Close();

}Do you have a default database set? If not try this:

strcpy(sql_statement,_T("USE TEST; SELECT * FROM TestTabelle"));|||1. I dunno how i can set the "Test" Database as default on MS SQL Server

2. If i type "USE TEST;" like you said iam getting a big compiler or error message

:(|||ok, since modifying the logon properties appears to be not acceptible, try this:

strcpy(sql_statement,_T("SELECT * FROM Test.dbo.TestTabelle"));|||thx ms

i could modify the default settings... i will try this sql_statement too..

but somehow i am getting the errors know where i try to access the tabel field.

first one: index (int)
second: product (varchar)
third: price (float)

i ddin't found any error. weird ?

Tuesday, March 27, 2012

Connection Problem

Connection Problem

connection problem

connection problem

connection problem

Connection Problem

Connection problem

Connection problem

Connection Problem

Sunday, March 25, 2012

connection problem

connection problem

Connection Problem

connection problem

connection problem

connection problem

Connection problem

Connection problem

Connection Problem

connection problem

asp sql server

Blog Archive

About Me