Re: Transferring to a new computer

Thanks for your help. But the command did not work. I get can't find OSQL
-E or can't fine SQLCMD -E

"Hari Prasad" wrote:

Hello,

Login in to the new SQL Server computer as OS user with local admin rights
and execute:-

for SQL 2005

SQLCMD -E

for

SQL 2000

OSQL -E

See if the command works...

Thanks
Hari

"Joe" <Joe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A67753E7-FB2D-4437-8138-0E5AAEFCF447@xxxxxxxxxxxxxxxx
I see the SQL Server manager running on the new computer as long as the old
server is running. What else should I be looing for?

"Hari Prasad" wrote:

Hello,

See the SQL Server service running in new SQL Server computer...

Thanks
Hari

"Joe" <Joe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FB7FA64B-0298-446E-A524-E16C9F8E69CE@xxxxxxxxxxxxxxxx
I am not a SQL person but was asked to work on it. The problem I am
having
is that I cannot connect to the SQL Server unless the old computer is
running. I have transferred all the settings and files to the new
computer
and am able to run the sqlomgr.exe. But it will not stay active when
the
old
computer is shut down. Both the old and the new computer is running
Windows
XP Professional. There is only one application which uses the SQL
Server.
What else is missing so that I can run the SQL from the new computer
only.






.

Relevant Pages

  • Re: Create Job to dump SP results into a text file.
    ... But its output is in a strange format. ... > As the first content you get, it is because the missing of some switches in> the OSQL utility, and the -L is an exclusive switch in osql utility, so you> get the content of 'The -L parameter can not used in combineation with> others parameters.' ... Could you connect the SQL Server via Query Analyzer by SQL Server> authentication using 'sa'? ...
    (microsoft.public.sqlserver.programming)
  • Re: Script works in SQLCMD, need to run it in OSQL or similar
    ... need to run them on a SQL Server 7 database server. ... SQLCMD, but it does have OSQL. ... coexist with installations that have ISQL or OSQL installed." ...
    (microsoft.public.sqlserver.tools)
  • Script works in SQLCMD, need to run it in OSQL or similar
    ... I have a set of extract scripts that I can run using SQLCMD, ... need to run them on a SQL Server 7 database server. ... SQLS7 doesn't have ... but it does have OSQL. ...
    (microsoft.public.sqlserver.tools)
  • Re: Create Job to dump SP results into a text file.
    ... the OSQL utility, and the -L is an exclusive switch in osql utility, so you ... Could you connect the SQL Server via Query Analyzer by SQL Server ... To enable TCP/IP server network library by the Server Network Utility, ...
    (microsoft.public.sqlserver.programming)
  • Re: Can you use osql in DTS?
    ... Columnist, SQL Server Professional ... > osql. ... > DECLARE @curDate As DateTime ... > @chartime into a stored procedure that I would call. ...
    (microsoft.public.sqlserver.programming)