MSSQL Mistake: remote

Showing posts with label remote. Show all posts

Friday, March 23, 2012

Muliprotocol Encryption with Firewall ?

quote:

> Hi,
> I'm trying to setup a connection between a remote SQL server 2000 and

Query

quote:

> Analyser using an encrypted Multiprotocol connection but because the SQL
> server is sitting behind a firewall I'm having trouble finding a way to
> connect - is there any way to specify the port that the SQL server listens
> on for this protocol rather than the default random assignment ?
> Thanks,
> Dave.
>

|||No - SSL sounds good - what port does that connect on though ?
Thanks,
Dave.
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:#GyTNnc4DHA.876@.TK2MSFTNGP10.phx.gbl...

quote:

> Any reason you can't use SSL ? Just wondering why you are using
> multiprotocol as it is really just included in SQL2000 for backwards
> compatability.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Dave LLoyd" <dlloyd2000@.hotmasl.com> wrote in message
> news:epWo4Vc4DHA.2168@.TK2MSFTNGP12.phx.gbl...
> Query
listens[QUOTE]
>

|||It works at the SuperSocket Net-Library level so no new ports are required
to be open. You can use TCP/IP, Named Pipes etc as it sits behind them all.
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dave LLoyd" <dlloyd2000@.hotmasl.com> wrote in message
news:ODHODCd4DHA.1428@.TK2MSFTNGP12.phx.gbl...

quote:

> No - SSL sounds good - what port does that connect on though ?
> Thanks,
> Dave.
>
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:#GyTNnc4DHA.876@.TK2MSFTNGP10.phx.gbl...
SQL[QUOTE]
to[QUOTE]
> listens
>

|||Thanks !
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:uJhhgAe4DHA.3436@.tk2msftngp13.phx.gbl...

quote:

> It works at the SuperSocket Net-Library level so no new ports are required
> to be open. You can use TCP/IP, Named Pipes etc as it sits behind them

all.

quote:

> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Dave LLoyd" <dlloyd2000@.hotmasl.com> wrote in message
> news:ODHODCd4DHA.1428@.TK2MSFTNGP12.phx.gbl...
and[QUOTE]
> SQL
> to
>

Muliprotocol Encryption with Firewall ?

Hi,
I'm trying to setup a connection between a remote SQL server 2000 and Query
Analyser using an encrypted Multiprotocol connection but because the SQL
server is sitting behind a firewall I'm having trouble finding a way to
connect - is there any way to specify the port that the SQL server listens
on for this protocol rather than the default random assignment ?
Thanks,
Dave.Any reason you can't use SSL ? Just wondering why you are using
multiprotocol as it is really just included in SQL2000 for backwards
compatability.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dave LLoyd" <dlloyd2000@.hotmasl.com> wrote in message
news:epWo4Vc4DHA.2168@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I'm trying to setup a connection between a remote SQL server 2000 and
Query
> Analyser using an encrypted Multiprotocol connection but because the SQL
> server is sitting behind a firewall I'm having trouble finding a way to
> connect - is there any way to specify the port that the SQL server listens
> on for this protocol rather than the default random assignment ?
> Thanks,
> Dave.
>|||No - SSL sounds good - what port does that connect on though ?
Thanks,
Dave.
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:#GyTNnc4DHA.876@.TK2MSFTNGP10.phx.gbl...
> Any reason you can't use SSL ? Just wondering why you are using
> multiprotocol as it is really just included in SQL2000 for backwards
> compatability.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Dave LLoyd" <dlloyd2000@.hotmasl.com> wrote in message
> news:epWo4Vc4DHA.2168@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > I'm trying to setup a connection between a remote SQL server 2000 and
> Query
> > Analyser using an encrypted Multiprotocol connection but because the SQL
> > server is sitting behind a firewall I'm having trouble finding a way to
> > connect - is there any way to specify the port that the SQL server
listens
> > on for this protocol rather than the default random assignment ?
> >
> > Thanks,
> >
> > Dave.
> >
> >
>|||It works at the SuperSocket Net-Library level so no new ports are required
to be open. You can use TCP/IP, Named Pipes etc as it sits behind them all.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dave LLoyd" <dlloyd2000@.hotmasl.com> wrote in message
news:ODHODCd4DHA.1428@.TK2MSFTNGP12.phx.gbl...
> No - SSL sounds good - what port does that connect on though ?
> Thanks,
> Dave.
>
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:#GyTNnc4DHA.876@.TK2MSFTNGP10.phx.gbl...
> > Any reason you can't use SSL ? Just wondering why you are using
> > multiprotocol as it is really just included in SQL2000 for backwards
> > compatability.
> >
> > --
> > HTH
> >
> > Jasper Smith (SQL Server MVP)
> >
> > I support PASS - the definitive, global
> > community for SQL Server professionals -
> > http://www.sqlpass.org
> >
> >
> > "Dave LLoyd" <dlloyd2000@.hotmasl.com> wrote in message
> > news:epWo4Vc4DHA.2168@.TK2MSFTNGP12.phx.gbl...
> > > Hi,
> > >
> > > I'm trying to setup a connection between a remote SQL server 2000 and
> > Query
> > > Analyser using an encrypted Multiprotocol connection but because the
SQL
> > > server is sitting behind a firewall I'm having trouble finding a way
to
> > > connect - is there any way to specify the port that the SQL server
> listens
> > > on for this protocol rather than the default random assignment ?
> > >
> > > Thanks,
> > >
> > > Dave.
> > >
> > >
> >
> >
>|||Thanks !
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:uJhhgAe4DHA.3436@.tk2msftngp13.phx.gbl...
> It works at the SuperSocket Net-Library level so no new ports are required
> to be open. You can use TCP/IP, Named Pipes etc as it sits behind them
all.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Dave LLoyd" <dlloyd2000@.hotmasl.com> wrote in message
> news:ODHODCd4DHA.1428@.TK2MSFTNGP12.phx.gbl...
> > No - SSL sounds good - what port does that connect on though ?
> >
> > Thanks,
> >
> > Dave.
> >
> >
> > "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> > news:#GyTNnc4DHA.876@.TK2MSFTNGP10.phx.gbl...
> > > Any reason you can't use SSL ? Just wondering why you are using
> > > multiprotocol as it is really just included in SQL2000 for backwards
> > > compatability.
> > >
> > > --
> > > HTH
> > >
> > > Jasper Smith (SQL Server MVP)
> > >
> > > I support PASS - the definitive, global
> > > community for SQL Server professionals -
> > > http://www.sqlpass.org
> > >
> > >
> > > "Dave LLoyd" <dlloyd2000@.hotmasl.com> wrote in message
> > > news:epWo4Vc4DHA.2168@.TK2MSFTNGP12.phx.gbl...
> > > > Hi,
> > > >
> > > > I'm trying to setup a connection between a remote SQL server 2000
and
> > > Query
> > > > Analyser using an encrypted Multiprotocol connection but because the
> SQL
> > > > server is sitting behind a firewall I'm having trouble finding a way
> to
> > > > connect - is there any way to specify the port that the SQL server
> > listens
> > > > on for this protocol rather than the default random assignment ?
> > > >
> > > > Thanks,
> > > >
> > > > Dave.
> > > >
> > > >
> > >
> > >
> >
> >
>

Muliprotocol Encryption with Firewall ?

quote:

> Hi,
> I'm trying to setup a connection between a remote SQL server 2000 and

Query

quote:

> Analyser using an encrypted Multiprotocol connection but because the SQL
> server is sitting behind a firewall I'm having trouble finding a way to
> connect - is there any way to specify the port that the SQL server listens
> on for this protocol rather than the default random assignment ?
> Thanks,
> Dave.
>

|||No - SSL sounds good - what port does that connect on though ?
Thanks,
Dave.
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:#GyTNnc4DHA.876@.TK2MSFTNGP10.phx.gbl...

quote:

> Any reason you can't use SSL ? Just wondering why you are using
> multiprotocol as it is really just included in SQL2000 for backwards
> compatability.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Dave LLoyd" <dlloyd2000@.hotmasl.com> wrote in message
> news:epWo4Vc4DHA.2168@.TK2MSFTNGP12.phx.gbl...
> Query
listens[QUOTE]
>

quote:

> No - SSL sounds good - what port does that connect on though ?
> Thanks,
> Dave.
>
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:#GyTNnc4DHA.876@.TK2MSFTNGP10.phx.gbl...
SQL[QUOTE]
to[QUOTE]
> listens
>

|||Thanks !
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:uJhhgAe4DHA.3436@.tk2msftngp13.phx.gbl...

quote:

> It works at the SuperSocket Net-Library level so no new ports are required
> to be open. You can use TCP/IP, Named Pipes etc as it sits behind them

all.

quote:

> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Dave LLoyd" <dlloyd2000@.hotmasl.com> wrote in message
> news:ODHODCd4DHA.1428@.TK2MSFTNGP12.phx.gbl...
and[QUOTE]
> SQL
> to
>

|||Yes. You need to make a change in the registry on the SQL Server in order
to do this.
See the following kb for step by step example:
164667 INF: Replication Setup Over a Firewall
http://support.microsoft.com/?id=164667
The preferred method would be using SSL.
324777 Support WebCast: Microsoft SQL Server 2000: How to Configure SSL
http://support.microsoft.com/?id=324777
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Friday, March 9, 2012

mssql8 AND mssql 2005

I have both 8 and 2005 installed on a windows 2003 server. However from a remote machine I can only see the 2005 instance. Is there a configuration I have missed or is this not possible?Are you using SQL Server 2005 Management Studio to connect to a remote database engine? If so, you may wanna try to select <Browse for more...> option from the Server Name dropdown list and then switch to the Network Servers tab. Let me know how you're getting along.|||I can see both instances on the Windows 2003 system and can connect to the v8 thru sql server management as you suggest. My issue is a remote machine with only 8's client cannot connect to the mssql v8 instance.|||Are you getting any error at all? Try to quickly create a .udl file on the remote machine to see if you could make and test a connection to the server.|||I get a server not found message.|||How did you name your 2000 and 2005 instances on the same box?|||2005 = server
other is server\server2003|||And server\server2003 is not visible from 2000 client, right?|||Yes. I wonder if I should name it something else maybe it doesn;t like that name. Maybe OldSQL?|||

Quote:

Originally Posted by kitspid

Yes. I wonder if I should name it something else maybe it doesn;t like that name. Maybe OldSQL?

Try to name it without slash. I doubt though it'll help. I once experienced a very funny problem with my replication whereby the distributor wouldn't connect to the subscriber. I had to enable Naming Pipes on the subscriber via the SQL config console to fix it. Just a thought.|||Tried the name pipes didn;t help. Don;t think I can rename it as the machine is called server which is where that comes from shoulf just be server2003 to connect. Going to move this db to a different machine and not worry about it anymore. Chalk it up to a 2005 quirk I think.|||Thanx for your help anyway.|||Good luck to you. Sorry couldn't help you better. Try to search in MSDN troubleshooting articles.|||I had to change the port for the mssql8 version to get it to work.

Wednesday, March 7, 2012

mssql2000 on emc mirrorview volume

Hello!

Does anybody know whether mssql2000 and emc mirrorvew _certified_ for
joint work?

(Mirrorview is a fc-based remote mirroring solution)

I mean is it supported from the MS point of view to put mssql
datafiles on emc mirrorview volumes?

For example Oracle corp. has "Oracle Compatible Remote Mirroring
Technologies" certification.

But what about MS?inq_3@.hotmail.com (Inquisitive) wrote in message news:<85197477.0407110459.26c9b313@.posting.google.com>...
> Hello!
> Does anybody know whether mssql2000 and emc mirrorvew _certified_ for
> joint work?
> (Mirrorview is a fc-based remote mirroring solution)
> I mean is it supported from the MS point of view to put mssql
> datafiles on emc mirrorview volumes?
> For example Oracle corp. has "Oracle Compatible Remote Mirroring
> Technologies" certification.
> But what about MS?

I have no idea about that specific piece of hardware, but you might
want to ask EMC if it's certified for use with MSSQL (or indeed ask
Microsoft also). Microsoft's attitude appears to be that you can use
any hardware you want, but if it's not WHQL certified, then problems
will be referred back to the vendor:

http://support.microsoft.com/defaul...1&Product=sql2k

You could also want to look at "Snapshot Backups" in Books Online, if
that's relevant to what you're trying to do.

Simon

Monday, February 20, 2012

mssql remote gui

Can anyone recommend a FREE Microsoft SQL Server GUI that I can use to
run some basic queries and browse tables for a remote MSSQL database.
I installed the freeware from TOAD, but it screwed up my computer, I
am really looking for something light weight, nothing fancy needed,
for some basic queries and browsing. If I connect to the server I use
the Enterprise Manager, but really didn't want to have to install a
copy of MSSQL on my local machine just to use the Enterprise Manager
if there was a good free GUI.
Thanks
Perhaps http://rac4sql.net/qalite_main.asp ?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<trpost@.gmail.com> wrote in message news:1186192697.704881.325630@.i13g2000prf.googlegr oups.com...
> Can anyone recommend a FREE Microsoft SQL Server GUI that I can use to
> run some basic queries and browse tables for a remote MSSQL database.
> I installed the freeware from TOAD, but it screwed up my computer, I
> am really looking for something light weight, nothing fancy needed,
> for some basic queries and browsing. If I connect to the server I use
> the Enterprise Manager, but really didn't want to have to install a
> copy of MSSQL on my local machine just to use the Enterprise Manager
> if there was a good free GUI.
> Thanks
>
|||In addition to QA lite, have you looked at Management Studio Express
Edition?
Aaron Bertrand
SQL Server MVP
<trpost@.gmail.com> wrote in message
news:1186192697.704881.325630@.i13g2000prf.googlegr oups.com...
> Can anyone recommend a FREE Microsoft SQL Server GUI that I can use to
> run some basic queries and browse tables for a remote MSSQL database.
> I installed the freeware from TOAD, but it screwed up my computer, I
> am really looking for something light weight, nothing fancy needed,
> for some basic queries and browsing. If I connect to the server I use
> the Enterprise Manager, but really didn't want to have to install a
> copy of MSSQL on my local machine just to use the Enterprise Manager
> if there was a good free GUI.
> Thanks
>
|||Hello trpost@.gmail.com,

> Can anyone recommend a FREE Microsoft SQL Server GUI that I can use to
> run some basic queries and browse tables for a remote MSSQL database.
> I installed the freeware from TOAD, but it screwed up my computer, I
> am really looking for something light weight, nothing fancy needed,
> for some basic queries and browsing. If I connect to the server I use
> the Enterprise Manager, but really didn't want to have to install a
> copy of MSSQL on my local machine just to use the Enterprise Manager
> if there was a good free GUI.
> Thanks
>
When you start the setup of SQL Server youw ill be presented an option to
just install the Client tools & Connectivity. IT should give you just the
tools, not the whole server.
Jesse

mssql remote gui

Can anyone recommend a FREE Microsoft SQL Server GUI that I can use to
run some basic queries and browse tables for a remote MSSQL database.
I installed the freeware from TOAD, but it screwed up my computer, I
am really looking for something light weight, nothing fancy needed,
for some basic queries and browsing. If I connect to the server I use
the Enterprise Manager, but really didn't want to have to install a
copy of MSSQL on my local machine just to use the Enterprise Manager
if there was a good free GUI.
ThanksPerhaps http://rac4sql.net/qalite_main.asp ?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<trpost@.gmail.com> wrote in message news:1186192697.704881.325630@.i13g2000prf.googlegroups.c
om...
> Can anyone recommend a FREE Microsoft SQL Server GUI that I can use to
> run some basic queries and browse tables for a remote MSSQL database.
> I installed the freeware from TOAD, but it screwed up my computer, I
> am really looking for something light weight, nothing fancy needed,
> for some basic queries and browsing. If I connect to the server I use
> the Enterprise Manager, but really didn't want to have to install a
> copy of MSSQL on my local machine just to use the Enterprise Manager
> if there was a good free GUI.
> Thanks
>|||In addition to QA lite, have you looked at Management Studio Express
Edition?
Aaron Bertrand
SQL Server MVP
<trpost@.gmail.com> wrote in message
news:1186192697.704881.325630@.i13g2000prf.googlegroups.com...
> Can anyone recommend a FREE Microsoft SQL Server GUI that I can use to
> run some basic queries and browse tables for a remote MSSQL database.
> I installed the freeware from TOAD, but it screwed up my computer, I
> am really looking for something light weight, nothing fancy needed,
> for some basic queries and browsing. If I connect to the server I use
> the Enterprise Manager, but really didn't want to have to install a
> copy of MSSQL on my local machine just to use the Enterprise Manager
> if there was a good free GUI.
> Thanks
>|||Hello trpost@.gmail.com,

> Can anyone recommend a FREE Microsoft SQL Server GUI that I can use to
> run some basic queries and browse tables for a remote MSSQL database.
> I installed the freeware from TOAD, but it screwed up my computer, I
> am really looking for something light weight, nothing fancy needed,
> for some basic queries and browsing. If I connect to the server I use
> the Enterprise Manager, but really didn't want to have to install a
> copy of MSSQL on my local machine just to use the Enterprise Manager
> if there was a good free GUI.
> Thanks
>
When you start the setup of SQL Server youw ill be presented an option to
just install the Client tools & Connectivity. IT should give you just the
tools, not the whole server.
Jesse

mssql remote gui

Can anyone recommend a FREE Microsoft SQL Server GUI that I can use to
run some basic queries and browse tables for a remote MSSQL database.
I installed the freeware from TOAD, but it screwed up my computer, I
am really looking for something light weight, nothing fancy needed,
for some basic queries and browsing. If I connect to the server I use
the Enterprise Manager, but really didn't want to have to install a
copy of MSSQL on my local machine just to use the Enterprise Manager
if there was a good free GUI.
ThanksPerhaps http://rac4sql.net/qalite_main.asp ?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<trpost@.gmail.com> wrote in message news:1186192697.704881.325630@.i13g2000prf.googlegroups.com...
> Can anyone recommend a FREE Microsoft SQL Server GUI that I can use to
> run some basic queries and browse tables for a remote MSSQL database.
> I installed the freeware from TOAD, but it screwed up my computer, I
> am really looking for something light weight, nothing fancy needed,
> for some basic queries and browsing. If I connect to the server I use
> the Enterprise Manager, but really didn't want to have to install a
> copy of MSSQL on my local machine just to use the Enterprise Manager
> if there was a good free GUI.
> Thanks
>|||In addition to QA lite, have you looked at Management Studio Express
Edition?
--
Aaron Bertrand
SQL Server MVP
<trpost@.gmail.com> wrote in message
news:1186192697.704881.325630@.i13g2000prf.googlegroups.com...
> Can anyone recommend a FREE Microsoft SQL Server GUI that I can use to
> run some basic queries and browse tables for a remote MSSQL database.
> I installed the freeware from TOAD, but it screwed up my computer, I
> am really looking for something light weight, nothing fancy needed,
> for some basic queries and browsing. If I connect to the server I use
> the Enterprise Manager, but really didn't want to have to install a
> copy of MSSQL on my local machine just to use the Enterprise Manager
> if there was a good free GUI.
> Thanks
>|||Hello trpost@.gmail.com,
> Can anyone recommend a FREE Microsoft SQL Server GUI that I can use to
> run some basic queries and browse tables for a remote MSSQL database.
> I installed the freeware from TOAD, but it screwed up my computer, I
> am really looking for something light weight, nothing fancy needed,
> for some basic queries and browsing. If I connect to the server I use
> the Enterprise Manager, but really didn't want to have to install a
> copy of MSSQL on my local machine just to use the Enterprise Manager
> if there was a good free GUI.
> Thanks
>
When you start the setup of SQL Server youw ill be presented an option to
just install the Client tools & Connectivity. IT should give you just the
tools, not the whole server.
Jess

MSSQL Remote Access: Can't find solution after 6 hours of searching...

Hello,
I'm trying to access the MSSQl 'remotey'. I open telnet and go to 127.0.0.1 1433 but can't. It seems I have done everything I can to fix it, but nothing solves the problem.

My firewall is disabled.

I have TCP/IP enabled in "SQL Server Configuration Manager" for both Client Protocol and protocols for MSSSQLSERVER (Shared Memory and NAmed Pipes are also both enabled). VIA is disabled.

In SQL Services, SQL Server Integration Services, Full Text Searc, SQL Server, SQL Server Analysis Services, and Server Browser are running. SQL Server Agent is disabled.

In Server Surface Area configuration, under Database Engine is running (automatic) and "Remote Connections" is enabled to TCP/IP and named pipes. Analysis Service has Local and Remote connections checked and is running (automatic). SQL Server agent is stopped.

Integration Services is running (Automatic) SQL Server Browser is running. (Automatic)

When I look in the error log, it shows...

Date 1/4/2007 3:21:45 AM
Log SQL Server (Current - 1/4/2007 3:21:00 AM)

Source Server

Message
Server is listening on [ 127.0.0.1 <ipv4> 1434].

Date 1/4/2007 3:21:45 AM
Log SQL Server (Current - 1/4/2007 3:21:00 AM)

Source Server

Message
Server is listening on [ 'any' <ipv4> 1433].

I have tried to telnet to port 1434 and 1433 but nothing happens. Does anyone know what else I need to be able to access that port?

Thanks
FoleyOh yeah, this is with SQL Server 2005, Windows XP

Thanks.|||

Hi,

On Windows XP Pro you can install Express & Developer Edition ,Refer below KB and links for workaround

http://support.microsoft.com/kb/555585

http://www.teratrax.com/articles/connecting_sql_server_express.html

http://www.datamasker.com/SSE2005_NetworkCfg.htm

http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

Hemantgiri S. Goswami

MSSQL ODBC (SQL) connection issue (sqlstate 2800)

I am trying to make an ODBC connection to a MSSQL 2K server on a remote machine. I am using the SQL Server driver and can see the server in the drop down list when asked which server I would like to connect to. I am using SQL authentication over TCP/IP.

The error occurs when ODBC tries to connet to SQL server to obtain the default settings. The error I receive is as follows:

Connection Failed;
sqlstate '28000';
sql server error: 18456;
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'XXXX'

I have tried setting up alternate SQL Server users with varying security rights on the server but am not able to setup the ODBC connection.

I am setting the ODBC connection up on a windows XP SP2 machine.
The remote server is running Windows server 2003 (patched upto date) and MS SQL server 2K (SP3). The connection is over a LAN and does not pass through any firewalls (hardware or software). I can create the ODBC connection without issue locally on the server.

This is my first time creating an ODBC connection to a Windows 2003 Server and I am wondering if there is some additional config I may have missed out.

Many thanks.what authentication mode is your sql server running in? windows only or mixed mode?|||The server is running in mixed mode for this instance. I have tried connecting using windows authentication, but the connection times out at the same stage as above.

Many thanks.|||1. make sure that you can ping the server
2. Open your Security\Logins, check the "Database Access" and "Server Roles" that are set to the correct setting.

Friday, March 23, 2012

Muliprotocol Encryption with Firewall ?

Muliprotocol Encryption with Firewall ?

Muliprotocol Encryption with Firewall ?

Friday, March 9, 2012

mssql8 AND mssql 2005

Wednesday, March 7, 2012

mssql2000 on emc mirrorview volume

Monday, February 20, 2012

mssql remote gui

mssql remote gui

mssql remote gui

MSSQL Remote Access: Can't find solution after 6 hours of searching...

MSSQL ODBC (SQL) connection issue (sqlstate 2800)

MSSQL Mistake

Blog Archive

About Me