Re: Transferring to a new computer

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: 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: Transferring to a new computer
    ... I get can't find OSQL ... -E or can't fine SQLCMD -E ... "Hari Prasad" wrote: ... See the SQL Server service running in new SQL Server computer... ...
    (microsoft.public.sqlserver.connect)
  • Re: Script works in SQLCMD, need to run it in OSQL or similar
    ... need to run them on a SQL Server 7 database server. ... SQLS7 doesn't have ... SQLCMD, but it does have OSQL. ...
    (microsoft.public.sqlserver.tools)
  • Re: Join Domain
    ... tmccuan wrote: ... Perhaps you were not logged into the SQL server w/ local admin rights, ... Microsoft Windows 2000/NT MVP ...
    (microsoft.public.win2000.general)
Loading