all groups > sql server connect > october 2006 > threads for october 15 - 21, 2006
Filter by week: 1 2 3 4 5
Connect to an SQL 2005 server through proxy
Posted by IoannisKirmitzoglou NO[at]SPAM gmail.com at 10/21/2006 6:45:48 AM
Ok, here is the situation...
I have created an Access Project application which connects to our SQL
Server.
SQL server is not behind a proxy, it listens to the default port
Most of our users are outside the LAN and thus they connect through the
internet.
One of our users works in a university ... more >>
Can't connect to server using server management studio
Posted by Hooopla at 10/20/2006 5:01:06 PM
Hi,
For some reason I can't connect to a (remote) SQL server using SQL server
management studio (2005) from my local SQL 2005 Server. I can connect from
numerous other PCs/Servers in my site except this one. The local SQL Server
is running Windows 2003 R2.
It will accept the username (sa... more >>
SQL 2005 Mailing Error
Posted by Woo at 10/20/2006 2:42:01 AM
I have a SQL Job setup in SQL2005 that when there is something to report, via
a stored procedure, an email will be sent out via database mail.
Whenever it tries to send an email it fails with this error:
[SQLSTATE 01000] (Message 2528) Query execution failed: Error initializing
COM [SQLST... more >>
SQL ODBC Connection Problems
Posted by Matt Austin at 10/19/2006 9:02:02 AM
Hello,
When attempting to connect to a SQL DB through an Access front-end, I
receive the following error:
Connection failed.
SQLState: '28000'
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'(null)'. Reason: Not associated with a trusted SQL... more >>
Trusted connection over VPN
Posted by DNG at 10/18/2006 12:35:24 PM
I use VPN to connect to corporate network from home. VPN works fine and I
can use remote desktop to access the SQL box.. BUT, I am only allowed to use
trusted connections for SQL. I am developing applications at home PC (XP
Pro), which is not part of the domain. Is there a way that I can conne... more >>
connect to sql
Posted by js NO[at]SPAM someone.com at 10/18/2006 10:06:42 AM
Hi
I have two machine one is application server (asp) and one is database
server (sql 2000).
Between them, I use a crossover cable connect each other(1GB) and also they'
re all connect to internet use another network card(100 MB).
I test locally and the speed is good, but just found i... more >>
sql 2005 connection error
Posted by JD at 10/18/2006 9:13:15 AM
Hello,
I am dealing with an issue, that although probably simple, is driving me
crazy. I am trying to connect to a SQL 2005 Express database through a web
service using the following code:
[WebMethod]
public XmlDocument GetAllAuthors()
{
XmlDocument doc = new XmlDocument(... more >>
Net-Library errors every 48 hours
Posted by Dan Kimble at 10/17/2006 7:28:02 AM
At 2:00 AM every other morning we are getting errors that are causing us to
have to restart SQL Server 2000.
The event log registers the following:
Source: MSSQLSERVER
Event ID: 17052
Error: 17825, Severity: 18, State: 4
Could not close Net-Library ''.
We will also see the following erro... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Browser problem?
Posted by Axel at 10/17/2006 5:11:02 AM
I've installed SQL Server 2005 Express on Windows 2000 server. I've enabled
tcp/ip for remote connections. I also have SQL Server 7 on the same server.
I can connect to the SQL Server Express instance remotely if I specify the
dynamic port:
sqlcmd -S<ip address>\sqlexpress,<port number> -Usa -... more >>
Not associated with a trusted SQL Server connection
Posted by karthikeyan.rsm NO[at]SPAM gmail.com at 10/16/2006 9:36:19 PM
Hi can anyone help me on this
I am consistently getting the following error
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'sa'. Reason: Not associated with a trusted SQL
Server connection.
/test.asp, line 7
The connection string which i am using i... more >>
remote connection error 26
Posted by matt at 10/16/2006 3:17:02 PM
I receive an error 26 "Error locating server/instance specified" when trying
to connect to a named instance of sql2005 through sql server mgmt studio (i
can connect locally just not from a remote pc). I can also connect via the
old query analyzer to the remote sql2005 server.
I have enab... more >>
SQL 2005 & WSUS
Posted by Erik at 10/16/2006 2:15:34 PM
I'm trying to install WSUS with SP1 on my SQL 2005 server. When I'm on the
"Database option" page, the choice to choose an existing database is greyed
out. It will only allow me to continue with the MSDE option selected.
All of my SQL services are started as I have databases in use currentl... more >>
attach multiply databases
Posted by Keesb at 10/16/2006 11:54:12 AM
I have a new server with SQL2000. I have copied all my databases. Now I have
to attach them. Their are abouth 300 db's So it is a lot of work to attach
them one by one.
Is their a way to attach them all in one time?
Kees
... more >>
Connecting to SQL Server 7 using SQL Server 2005 Management Studio
Posted by Axel at 10/16/2006 5:05:01 AM
Is there a way to connect to SQL Server 7 using the new Management Studio?
/Axel
... more >>
|