SQL Configure: analyzer

Showing posts with label analyzer. Show all posts

Sunday, 25 March 2012

Connect to Remote SQL SERVER Express 2005 server

I am trying to connect to a remote SQL Express server (using query analyzer)
and I am not able to. If I run SQL Server Managemant Studio I can connect
(using Windows Authentication). I have tried using the IP address of the
server and just the server name but no luck. There is only one instance
running on the server (default). This server is on a different subnet. The
error I receive is: Server: Msg 14, Level 16, State1
[microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
Any ideas?
TimAre you sure the SQL Express instance is the default? It normally installs
as a named instance SQLEXPRESS.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Tim Kelley" <tkelley@.company.com> wrote in message
news:%23jgSL5QzGHA.4104@.TK2MSFTNGP02.phx.gbl...
>I am trying to connect to a remote SQL Express server (using query
>analyzer) and I am not able to. If I run SQL Server Managemant Studio I
>can connect (using Windows Authentication). I have tried using the IP
>address of the server and just the server name but no luck. There is only
>one instance running on the server (default). This server is on a
>different subnet. The error I receive is: Server: Msg 14, Level 16, State1
> [microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
> Any ideas?
> Tim
>|||You are right. When I try connecting using servername/sqlexpress I get the
following error:
[DBNETLIB][ConnectionOpen(Connect)).]SQL Server does not exist or Access
Denied.
Thanks,
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:O9BqpTRzGHA.1292@.TK2MSFTNGP03.phx.gbl...
> Are you sure the SQL Express instance is the default? It normally
> installs as a named instance SQLEXPRESS.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Tim Kelley" <tkelley@.company.com> wrote in message
> news:%23jgSL5QzGHA.4104@.TK2MSFTNGP02.phx.gbl...
>>I am trying to connect to a remote SQL Express server (using query
>>analyzer) and I am not able to. If I run SQL Server Managemant Studio I
>>can connect (using Windows Authentication). I have tried using the IP
>>address of the server and just the server name but no luck. There is only
>>one instance running on the server (default). This server is on a
>>different subnet. The error I receive is: Server: Msg 14, Level 16, State1
>> [microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
>> Any ideas?
>> Tim
>|||How about servername\sqlexpress ? Is the SQLBrowser enabled and running on
the SQL Express server?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Tim Kelley" <tkelley@.company.com> wrote in message
news:O5ps1hRzGHA.996@.TK2MSFTNGP03.phx.gbl...
> You are right. When I try connecting using servername/sqlexpress I get
> the following error:
> [DBNETLIB][ConnectionOpen(Connect)).]SQL Server does not exist or Access
> Denied.
> Thanks,
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:O9BqpTRzGHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Are you sure the SQL Express instance is the default? It normally
>> installs as a named instance SQLEXPRESS.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Use of included script samples are subject to the terms specified at
>> http://www.microsoft.com/info/cpyright.htm
>> "Tim Kelley" <tkelley@.company.com> wrote in message
>> news:%23jgSL5QzGHA.4104@.TK2MSFTNGP02.phx.gbl...
>>I am trying to connect to a remote SQL Express server (using query
>>analyzer) and I am not able to. If I run SQL Server Managemant Studio I
>>can connect (using Windows Authentication). I have tried using the IP
>>address of the server and just the server name but no luck. There is only
>>one instance running on the server (default). This server is on a
>>different subnet. The error I receive is: Server: Msg 14, Level 16,
>>State1
>> [microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
>> Any ideas?
>> Tim
>>
>|||Got the same error. I found a registry entry that fixed the problem.
HKLM\Software\Microsoft\MSSQLServer\Client\ConnectTo.
Added REG_SZ key <servername> with data set to:
<servername>,DBMSSOCN,<servername>,1433
Don't know what this does, but I am able to connect now.
Thanks,
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:uP3wAxRzGHA.2036@.TK2MSFTNGP05.phx.gbl...
> How about servername\sqlexpress ? Is the SQLBrowser enabled and running
> on the SQL Express server?
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Tim Kelley" <tkelley@.company.com> wrote in message
> news:O5ps1hRzGHA.996@.TK2MSFTNGP03.phx.gbl...
>> You are right. When I try connecting using servername/sqlexpress I get
>> the following error:
>> [DBNETLIB][ConnectionOpen(Connect)).]SQL Server does not exist or Access
>> Denied.
>> Thanks,
>>
>> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
>> news:O9BqpTRzGHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Are you sure the SQL Express instance is the default? It normally
>> installs as a named instance SQLEXPRESS.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Use of included script samples are subject to the terms specified at
>> http://www.microsoft.com/info/cpyright.htm
>> "Tim Kelley" <tkelley@.company.com> wrote in message
>> news:%23jgSL5QzGHA.4104@.TK2MSFTNGP02.phx.gbl...
>>I am trying to connect to a remote SQL Express server (using query
>>analyzer) and I am not able to. If I run SQL Server Managemant Studio I
>>can connect (using Windows Authentication). I have tried using the IP
>>address of the server and just the server name but no luck. There is
>>only one instance running on the server (default). This server is on a
>>different subnet. The error I receive is: Server: Msg 14, Level 16,
>>State1
>> [microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
>> Any ideas?
>> Tim
>>
>>
>

Connect to Remote SQL SERVER Express 2005 server

Tuesday, 20 March 2012

Connect to another server in Query Analyzer

Hello,
Is it possible to connect to another server and database using code in the
query analyze?. I'm trying to do the equivalent of ctrl+O with the name of
the server and database.
Any help with this would be appreciated.
--
Thanks in advance,
sck10No, once you execute code in QA, you execute that code in the SQL Server you are connected to. In
SQL Server 2005, the successor to OSQL, called SQLCMD, will have that feature.
Changing database is simple, though, using USE.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:u%237htHskFHA.3164@.TK2MSFTNGP15.phx.gbl...
> Hello,
> Is it possible to connect to another server and database using code in the
> query analyze?. I'm trying to do the equivalent of ctrl+O with the name of
> the server and database.
> Any help with this would be appreciated.
> --
> Thanks in advance,
> sck10
>

Connect to another server in Query Analyzer

Hello,
Is it possible to connect to another server and database using code in the
query analyze?. I'm trying to do the equivalent of ctrl+O with the name of
the server and database.
Any help with this would be appreciated.
Thanks in advance,
sck10
No, once you execute code in QA, you execute that code in the SQL Server you are connected to. In
SQL Server 2005, the successor to OSQL, called SQLCMD, will have that feature.
Changing database is simple, though, using USE.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:u%237htHskFHA.3164@.TK2MSFTNGP15.phx.gbl...
> Hello,
> Is it possible to connect to another server and database using code in the
> query analyze?. I'm trying to do the equivalent of ctrl+O with the name of
> the server and database.
> Any help with this would be appreciated.
> --
> Thanks in advance,
> sck10
>
sql sql

Connect to another server in Query Analyzer

Hello,
Is it possible to connect to another server and database using code in the
query analyze?. I'm trying to do the equivalent of ctrl+O with the name of
the server and database.
Any help with this would be appreciated.
Thanks in advance,
sck10No, once you execute code in QA, you execute that code in the SQL Server you
are connected to. In
SQL Server 2005, the successor to OSQL, called SQLCMD, will have that featur
e.
Changing database is simple, though, using USE.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:u%237htHskFHA.3164@.TK2MSFTNGP15.phx.gbl.
.
> Hello,
> Is it possible to connect to another server and database using code in the
> query analyze?. I'm trying to do the equivalent of ctrl+O with the name o
f
> the server and database.
> Any help with this would be appreciated.
> --
> Thanks in advance,
> sck10
>

connect to a SQL Server Personal Edition! Please help

Hi All,
I have a SQL Server Personal Edition installed in a PC running Windows XP
Prof. I can be accessed using Query Analyzer perfectly using SQL Server
authentication. However, I am unable to access it from another computer
using Query Analyzer. That computer also runs Windows XP Prof. The Personal
Edition SQL server can be found but just cannot get it connected.
Following is the error message from Query Analyzer:-
Sever: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied.
Please help!
Larry
Hi
Running XP SP2?
Firewall.
http://www.microsoft.com/sql/techinf...inxpsp2faq.asp
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Larry Cheung" <larry@.hohotech.com> wrote in message
news:#4CAtWfyEHA.1204@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I have a SQL Server Personal Edition installed in a PC running Windows XP
> Prof. I can be accessed using Query Analyzer perfectly using SQL Server
> authentication. However, I am unable to access it from another computer
> using Query Analyzer. That computer also runs Windows XP Prof. The
Personal
> Edition SQL server can be found but just cannot get it connected.
> Following is the error message from Query Analyzer:-
> Sever: Msg 17, Level 16, State 1
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
> access denied.
> Please help!
> Larry
>

connect to a SQL Server Personal Edition! Please help

Hi All,
I have a SQL Server Personal Edition installed in a PC running Windows XP
Prof. I can be accessed using Query Analyzer perfectly using SQL Server
authentication. However, I am unable to access it from another computer
using Query Analyzer. That computer also runs Windows XP Prof. The Personal
Edition SQL server can be found but just cannot get it connected.
Following is the error message from Query Analyzer:-
Sever: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or
access denied.
Please help!
LarryHi
Running XP SP2?
Firewall.
http://www.microsoft.com/sql/techin...faq.asp

Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Larry Cheung" <larry@.hohotech.com> wrote in message
news:#4CAtWfyEHA.1204@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I have a SQL Server Personal Edition installed in a PC running Windows XP
> Prof. I can be accessed using Query Analyzer perfectly using SQL Server
> authentication. However, I am unable to access it from another computer
> using Query Analyzer. That computer also runs Windows XP Prof. The
Personal
> Edition SQL server can be found but just cannot get it connected.
> Following is the error message from Query Analyzer:-
> Sever: Msg 17, Level 16, State 1
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does n
ot exist or
> access denied.
> Please help!
> Larry
>

Monday, 19 March 2012

CONNECT TO

Hello,
I have 3 registrations under a Server Group. They are all connected using
Windows NT. I was trying to use the following in SQL Query Analyzer to
execute a stored procedure that was in another registration I got the
following code from books on line:
EXEC SQL CONNECT TO "Reg2.Funds";
However, I get the error: Incorrect syntax near the keyword 'TO'.
Any help with this would be appreciated.
--
Thanks in advance,
sck10Thats for embedded SQL in C.
If you want to in SQL Server you can go by the four part name:
example:
Select * from [servername].[databasename].[owner].[objectname]
where servername can be left out if you are not using a linked server, if
you want to use a linked server (connect to any other SQL Server than the
actual one, or even another instance) you have to conigure that but adding a
new linked server.
HTH, Jens Suessmeyer.
"sck10" <sck10@.online.nospam> wrote in message
news:O9rgf2YiFHA.1480@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I have 3 registrations under a Server Group. They are all connected using
> Windows NT. I was trying to use the following in SQL Query Analyzer to
> execute a stored procedure that was in another registration I got the
> following code from books on line:
> EXEC SQL CONNECT TO "Reg2.Funds";
> However, I get the error: Incorrect syntax near the keyword 'TO'.
> Any help with this would be appreciated.
> --
> Thanks in advance,
> sck10
>|||Hi sck10,
Thanks for your posting!
Based on my knowledge, CONNECT TO is embedded SQL for C. You cannot use it
in Query Analyzer directly. To call another SQL Server's stored procedure,
add another SQL Server as linked server and then call using the four parts
naming: [Server].[Database].[Owner].[Object]
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

CONNECT TO

Hello,
I have 3 registrations under a Server Group. They are all connected using
Windows NT. I was trying to use the following in SQL Query Analyzer to
execute a stored procedure that was in another registration I got the
following code from books on line:
EXEC SQL CONNECT TO "Reg2.Funds";
However, I get the error: Incorrect syntax near the keyword 'TO'.
Any help with this would be appreciated.
Thanks in advance,
sck10
Thats for embedded SQL in C.
If you want to in SQL Server you can go by the four part name:
example:
Select * from [servername].[databasename].[owner].[objectname]
where servername can be left out if you are not using a linked server, if
you want to use a linked server (connect to any other SQL Server than the
actual one, or even another instance) you have to conigure that but adding a
new linked server.
HTH, Jens Suessmeyer.
"sck10" <sck10@.online.nospam> wrote in message
news:O9rgf2YiFHA.1480@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I have 3 registrations under a Server Group. They are all connected using
> Windows NT. I was trying to use the following in SQL Query Analyzer to
> execute a stored procedure that was in another registration I got the
> following code from books on line:
> EXEC SQL CONNECT TO "Reg2.Funds";
> However, I get the error: Incorrect syntax near the keyword 'TO'.
> Any help with this would be appreciated.
> --
> Thanks in advance,
> sck10
>
|||Hi sck10,
Thanks for your posting!
Based on my knowledge, CONNECT TO is embedded SQL for C. You cannot use it
in Query Analyzer directly. To call another SQL Server's stored procedure,
add another SQL Server as linked server and then call using the four parts
naming: [Server].[Database].[Owner].[Object]
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

CONNECT TO

Hello,
I have 3 registrations under a Server Group. They are all connected using
Windows NT. I was trying to use the following in SQL Query Analyzer to
execute a stored procedure that was in another registration I got the
following code from books on line:
EXEC SQL CONNECT TO "Reg2.Funds";
However, I get the error: Incorrect syntax near the keyword 'TO'.
Any help with this would be appreciated.
Thanks in advance,
sck10Thats for embedded SQL in C.
If you want to in SQL Server you can go by the four part name:
example:
Select * from [servername].[databasename].[owner].[objectnam
e]
where servername can be left out if you are not using a linked server, if
you want to use a linked server (connect to any other SQL Server than the
actual one, or even another instance) you have to conigure that but adding a
new linked server.
HTH, Jens Suessmeyer.
"sck10" <sck10@.online.nospam> wrote in message
news:O9rgf2YiFHA.1480@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I have 3 registrations under a Server Group. They are all connected using
> Windows NT. I was trying to use the following in SQL Query Analyzer to
> execute a stored procedure that was in another registration I got the
> following code from books on line:
> EXEC SQL CONNECT TO "Reg2.Funds";
> However, I get the error: Incorrect syntax near the keyword 'TO'.
> Any help with this would be appreciated.
> --
> Thanks in advance,
> sck10
>|||Hi sck10,
Thanks for your posting!
Based on my knowledge, CONNECT TO is embedded SQL for C. You cannot use it
in Query Analyzer directly. To call another SQL Server's stored procedure,
add another SQL Server as linked server and then call using the four parts
naming: [Server].[Database].[Owner].[Object]
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

connect the SQL Server in different domains

HI ALL
I have tow domains, in the same forest. From one domain, which has a SQL Ser
ver A , I want to use the Enterprise manager or the Query Analyzer to connec
t the SQL Server B in the other domain and vise versa. Could any one elabora
te all the method to do tha
t.
thank you very much.I'm assuming this is more than just opening Query Analyzer and connecting to
a server name. What you probably want to do is add a linked server -- go to
SQL Enterprise Manager and add a new linked server under the security
section. That will let you run queries such as
select * from serverb.<database>.<owner>.<table>
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"ALLEN" <anonymous@.discussions.microsoft.com> wrote in message
news:3F57F4DF-7BB7-4C66-A362-5C112F850ABE@.microsoft.com...
> HI ALL
> I have tow domains, in the same forest. From one domain, which has a SQL
Server A , I want to use the Enterprise manager or the Query Analyzer to
connect the SQL Server B in the other domain and vise versa. Could any one
elaborate all the method to do that.
> thank you very much.|||You should not find any difference in normal connectivity, but there is one
thing that you might want to be aware of in this particular scenario. If you
want to use Kerberos Authenticatin then you will have to register an SPN for
the SQL Server using NETBIOS name.
Generally SPN should be registered in the following format
MSSQLSvc/sqlmachine.domain.net:1433 sqlserviceact
But to enable Kerberos protocol in this inter domain scenario, you will also
need to register an SPN using the NETBIOS name
MSSQLSvc/sqlmachine:1433 sqlserviceact
Thanks,
Bala.
This posting is provided "AS IS" with no warranties, and confers no
rights.
"ALLEN" <anonymous@.discussions.microsoft.com> wrote in message
news:3F57F4DF-7BB7-4C66-A362-5C112F850ABE@.microsoft.com...
> HI ALL
> I have tow domains, in the same forest. From one domain, which has a SQL
Server A , I want to use the Enterprise manager or the Query Analyzer to
connect the SQL Server B in the other domain and vise versa. Could any one
elaborate all the method to do that.
> thank you very much.

Sunday, 11 March 2012

Connect from SQL server to Excel file

Is it possible to connect from SQL server directly to .xls file ?
I imagine someting like opening .xls file in Query Analyzer to perform slect
into

You can use a linked server. Take a look at this topic from Books Online
"sp_addlinkedserver"
http://msdn.microsoft.com/library/de..._adda_8gqa.asp
Cristian Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET
"Mikus" <Mikus@.discussions.microsoft.com> wrote in message
news:CFDDF854-1800-4B8A-ABBA-3AE7BAB55E32@.microsoft.com...
> Is it possible to connect from SQL server directly to .xls file ?
> I imagine someting like opening .xls file in Query Analyzer to perform
> slect
> into

|||In addition to using a Linked Server as Cristian suggested, you can also use
the OPENQUERY command.
--Brian
(Please reply to the newsgroups only.)
"Cristian Lefter" <nospam_CristianLefter@.hotmail.com> wrote in message
news:eeETVNHsFHA.1172@.TK2MSFTNGP11.phx.gbl...
> You can use a linked server. Take a look at this topic from Books Online
> "sp_addlinkedserver"
> http://msdn.microsoft.com/library/de..._adda_8gqa.asp
> Cristian Lefter, SQL Server MVP
> MCT, MCSA, MCDBA, MCAD, MCSD .NET
> "Mikus" <Mikus@.discussions.microsoft.com> wrote in message
> news:CFDDF854-1800-4B8A-ABBA-3AE7BAB55E32@.microsoft.com...
>

Connect from SQL server to Excel file

Is it possible to connect from SQL server directly to .xls file ?
I imagine someting like opening .xls file in Query Analyzer to perform slect
into :)You can use a linked server. Take a look at this topic from Books Online
"sp_addlinkedserver"
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_8gqa.asp
Cristian Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET
"Mikus" <Mikus@.discussions.microsoft.com> wrote in message
news:CFDDF854-1800-4B8A-ABBA-3AE7BAB55E32@.microsoft.com...
> Is it possible to connect from SQL server directly to .xls file ?
> I imagine someting like opening .xls file in Query Analyzer to perform
> slect
> into :)|||In addition to using a Linked Server as Cristian suggested, you can also use
the OPENQUERY command.
--
--Brian
(Please reply to the newsgroups only.)
"Cristian Lefter" <nospam_CristianLefter@.hotmail.com> wrote in message
news:eeETVNHsFHA.1172@.TK2MSFTNGP11.phx.gbl...
> You can use a linked server. Take a look at this topic from Books Online
> "sp_addlinkedserver"
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_8gqa.asp
> Cristian Lefter, SQL Server MVP
> MCT, MCSA, MCDBA, MCAD, MCSD .NET
> "Mikus" <Mikus@.discussions.microsoft.com> wrote in message
> news:CFDDF854-1800-4B8A-ABBA-3AE7BAB55E32@.microsoft.com...
>> Is it possible to connect from SQL server directly to .xls file ?
>> I imagine someting like opening .xls file in Query Analyzer to perform
>> slect
>> into :)
>

Connect from SQL server to Excel file

Is it possible to connect from SQL server directly to .xls file ?
I imagine someting like opening .xls file in Query Analyzer to perform slect
into

You can use a linked server. Take a look at this topic from Books Online
"sp_addlinkedserver"
http://msdn.microsoft.com/library/d... />
a_8gqa.asp
Cristian Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET
"Mikus" <Mikus@.discussions.microsoft.com> wrote in message
news:CFDDF854-1800-4B8A-ABBA-3AE7BAB55E32@.microsoft.com...
> Is it possible to connect from SQL server directly to .xls file ?
> I imagine someting like opening .xls file in Query Analyzer to perform
> slect
> into

|||In addition to using a Linked Server as Cristian suggested, you can also use
the OPENQUERY command.
--Brian
(Please reply to the newsgroups only.)
"Cristian Lefter" <nospam_CristianLefter@.hotmail.com> wrote in message
news:eeETVNHsFHA.1172@.TK2MSFTNGP11.phx.gbl...
> You can use a linked server. Take a look at this topic from Books Online
> "sp_addlinkedserver"
> http://msdn.microsoft.com/library/d...>
dda_8gqa.asp
> Cristian Lefter, SQL Server MVP
> MCT, MCSA, MCDBA, MCAD, MCSD .NET
> "Mikus" <Mikus@.discussions.microsoft.com> wrote in message
> news:CFDDF854-1800-4B8A-ABBA-3AE7BAB55E32@.microsoft.com...
>

Thursday, 8 March 2012

connect

Hello,
I'm having the strangest problem.
SQL 2000 on a Win 2003 server.
I'm trying to connect via the query analyzer to the sql server on
another box. It was working all fine yesterday. Actually, it didn't
work initially. But I restarted the service MSSQLSERVER and I was able
to connect.
I can ping the SQL server IP. I can even ping it by the computer name,
WINBOX. The SQLServer is named WINBOX too.
Any ideas?BTW I looked at this KB article http://support.microsoft.com/?id=328306
and none of that seems to be my situation.|||Interesting find today.
If I log in or map a drive on the win 2003k machine I'm fine.
But if I don't I get an connection error.
This is beyond the my access rights to the SQL server itself.
Won Lee wrote:
> Hello,
> I'm having the strangest problem.
> SQL 2000 on a Win 2003 server.
> I'm trying to connect via the query analyzer to the sql server on
> another box. It was working all fine yesterday. Actually, it didn't
> work initially. But I restarted the service MSSQLSERVER and I was able
> to connect.
> I can ping the SQL server IP. I can even ping it by the computer name,
> WINBOX. The SQLServer is named WINBOX too.
> Any ideas?
>

Sunday, 25 March 2012

Connect to Remote SQL SERVER Express 2005 server

Connect to Remote SQL SERVER Express 2005 server

Tuesday, 20 March 2012

Connect to another server in Query Analyzer

Connect to another server in Query Analyzer

Connect to another server in Query Analyzer

connect to a SQL Server Personal Edition! Please help

connect to a SQL Server Personal Edition! Please help

Monday, 19 March 2012

CONNECT TO

CONNECT TO

CONNECT TO

connect the SQL Server in different domains

Sunday, 11 March 2012

Connect from SQL server to Excel file

Connect from SQL server to Excel file

Connect from SQL server to Excel file

Thursday, 8 March 2012

connect

SQL Configure

Blog Archive

About Me