Is there a way in which I could capture the SQL (create table, insert...)
used by the Upsizing Wizard when moving from Access to SQL Server? Ideally
I'd like to be able to provide this to my users in the event that once we
completely phase out Access, they have something to "guide" them in the
creation/alteration of tables. Thanks in advance.
Hi
Run SQL Server Profiler on the target server.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SABmore" wrote:
> Is there a way in which I could capture the SQL (create table, insert...)
> used by the Upsizing Wizard when moving from Access to SQL Server? Ideally
> I'd like to be able to provide this to my users in the event that once we
> completely phase out Access, they have something to "guide" them in the
> creation/alteration of tables. Thanks in advance.
Showing posts with label wizard. Show all posts
Showing posts with label wizard. Show all posts
Saturday, February 25, 2012
Capturing SQL from Upsizing Wizard
Is there a way in which I could capture the SQL (create table, insert...)
used by the Upsizing Wizard when moving from Access to SQL Server? Ideally
I'd like to be able to provide this to my users in the event that once we
completely phase out Access, they have something to "guide" them in the
creation/alteration of tables. Thanks in advance.Hi
Run SQL Server Profiler on the target server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SABmore" wrote:
> Is there a way in which I could capture the SQL (create table, insert...)
> used by the Upsizing Wizard when moving from Access to SQL Server? Ideally
> I'd like to be able to provide this to my users in the event that once we
> completely phase out Access, they have something to "guide" them in the
> creation/alteration of tables. Thanks in advance.
used by the Upsizing Wizard when moving from Access to SQL Server? Ideally
I'd like to be able to provide this to my users in the event that once we
completely phase out Access, they have something to "guide" them in the
creation/alteration of tables. Thanks in advance.Hi
Run SQL Server Profiler on the target server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SABmore" wrote:
> Is there a way in which I could capture the SQL (create table, insert...)
> used by the Upsizing Wizard when moving from Access to SQL Server? Ideally
> I'd like to be able to provide this to my users in the event that once we
> completely phase out Access, they have something to "guide" them in the
> creation/alteration of tables. Thanks in advance.
Capturing SQL from Upsizing Wizard
Is there a way in which I could capture the SQL (create table, insert...)
used by the Upsizing Wizard when moving from Access to SQL Server? Ideally
I'd like to be able to provide this to my users in the event that once we
completely phase out Access, they have something to "guide" them in the
creation/alteration of tables. Thanks in advance.Hi
Run SQL Server Profiler on the target server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SABmore" wrote:
> Is there a way in which I could capture the SQL (create table, insert...)
> used by the Upsizing Wizard when moving from Access to SQL Server? Ideall
y
> I'd like to be able to provide this to my users in the event that once we
> completely phase out Access, they have something to "guide" them in the
> creation/alteration of tables. Thanks in advance.
used by the Upsizing Wizard when moving from Access to SQL Server? Ideally
I'd like to be able to provide this to my users in the event that once we
completely phase out Access, they have something to "guide" them in the
creation/alteration of tables. Thanks in advance.Hi
Run SQL Server Profiler on the target server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SABmore" wrote:
> Is there a way in which I could capture the SQL (create table, insert...)
> used by the Upsizing Wizard when moving from Access to SQL Server? Ideall
y
> I'd like to be able to provide this to my users in the event that once we
> completely phase out Access, they have something to "guide" them in the
> creation/alteration of tables. Thanks in advance.
Tuesday, February 14, 2012
can't use the index tuning wizard wioth a function??
Hi,
I receive this error when I try to execute the index tuning wizard:
"There are no events in the workload. Either the trace
file contained no SQL batch or RPC events or the SQL
script contained no SQL queries."
I have tried from the query analyzer and from a workload trace file, in the
2 cases I receive the error.
My query contain a join to a custom function which return a simple list.
if I remove the function, then the index tuning works fine.
my query:
select * from table1 inner join dbo.MyFunction(@.Param) A on table1.ID =
A.ID
what can I do?
thanks.
Jerome.
Jj wrote:
> Hi,
> I receive this error when I try to execute the index tuning wizard:
> "There are no events in the workload. Either the trace
> file contained no SQL batch or RPC events or the SQL
> script contained no SQL queries."
> I have tried from the query analyzer and from a workload trace file,
> in the 2 cases I receive the error.
> My query contain a join to a custom function which return a simple
> list. if I remove the function, then the index tuning works fine.
> my query:
> select * from table1 inner join dbo.MyFunction(@.Param) A on
> table1.ID = A.ID
> what can I do?
> thanks.
> Jerome.
You probably chose the wrong template for recording of events in profiler.
There is a template SQLProfilerTuning. It should work with that one.
Kind regards
robert
|||I'm using standard templates which works fine with any query those with my
function.
but why I can't optimize from query analyzer?
"Robert Klemme" <bob.news@.gmx.net> wrote in message
news:e$XXF4wcFHA.2760@.tk2msftngp13.phx.gbl...
> Jj wrote:
> You probably chose the wrong template for recording of events in profiler.
> There is a template SQLProfilerTuning. It should work with that one.
> Kind regards
> robert
>
I receive this error when I try to execute the index tuning wizard:
"There are no events in the workload. Either the trace
file contained no SQL batch or RPC events or the SQL
script contained no SQL queries."
I have tried from the query analyzer and from a workload trace file, in the
2 cases I receive the error.
My query contain a join to a custom function which return a simple list.
if I remove the function, then the index tuning works fine.
my query:
select * from table1 inner join dbo.MyFunction(@.Param) A on table1.ID =
A.ID
what can I do?
thanks.
Jerome.
Jj wrote:
> Hi,
> I receive this error when I try to execute the index tuning wizard:
> "There are no events in the workload. Either the trace
> file contained no SQL batch or RPC events or the SQL
> script contained no SQL queries."
> I have tried from the query analyzer and from a workload trace file,
> in the 2 cases I receive the error.
> My query contain a join to a custom function which return a simple
> list. if I remove the function, then the index tuning works fine.
> my query:
> select * from table1 inner join dbo.MyFunction(@.Param) A on
> table1.ID = A.ID
> what can I do?
> thanks.
> Jerome.
You probably chose the wrong template for recording of events in profiler.
There is a template SQLProfilerTuning. It should work with that one.
Kind regards
robert
|||I'm using standard templates which works fine with any query those with my
function.
but why I can't optimize from query analyzer?
"Robert Klemme" <bob.news@.gmx.net> wrote in message
news:e$XXF4wcFHA.2760@.tk2msftngp13.phx.gbl...
> Jj wrote:
> You probably chose the wrong template for recording of events in profiler.
> There is a template SQLProfilerTuning. It should work with that one.
> Kind regards
> robert
>
can't use the index tuning wizard wioth a function??
Hi,
I receive this error when I try to execute the index tuning wizard:
"There are no events in the workload. Either the trace
file contained no SQL batch or RPC events or the SQL
script contained no SQL queries."
I have tried from the query analyzer and from a workload trace file, in the
2 cases I receive the error.
My query contain a join to a custom function which return a simple list.
if I remove the function, then the index tuning works fine.
my query:
select * from table1 inner join dbo.MyFunction(@.Param) A on table1.ID =
A.ID
what can I do?
thanks.
Jerome.Jj wrote:
> Hi,
> I receive this error when I try to execute the index tuning wizard:
> "There are no events in the workload. Either the trace
> file contained no SQL batch or RPC events or the SQL
> script contained no SQL queries."
> I have tried from the query analyzer and from a workload trace file,
> in the 2 cases I receive the error.
> My query contain a join to a custom function which return a simple
> list. if I remove the function, then the index tuning works fine.
> my query:
> select * from table1 inner join dbo.MyFunction(@.Param) A on
> table1.ID = A.ID
> what can I do?
> thanks.
> Jerome.
You probably chose the wrong template for recording of events in profiler.
There is a template SQLProfilerTuning. It should work with that one.
Kind regards
robert|||I'm using standard templates which works fine with any query those with my
function.
but why I can't optimize from query analyzer?
"Robert Klemme" <bob.news@.gmx.net> wrote in message
news:e$XXF4wcFHA.2760@.tk2msftngp13.phx.gbl...
> Jj wrote:
> You probably chose the wrong template for recording of events in profiler.
> There is a template SQLProfilerTuning. It should work with that one.
> Kind regards
> robert
>
I receive this error when I try to execute the index tuning wizard:
"There are no events in the workload. Either the trace
file contained no SQL batch or RPC events or the SQL
script contained no SQL queries."
I have tried from the query analyzer and from a workload trace file, in the
2 cases I receive the error.
My query contain a join to a custom function which return a simple list.
if I remove the function, then the index tuning works fine.
my query:
select * from table1 inner join dbo.MyFunction(@.Param) A on table1.ID =
A.ID
what can I do?
thanks.
Jerome.Jj wrote:
> Hi,
> I receive this error when I try to execute the index tuning wizard:
> "There are no events in the workload. Either the trace
> file contained no SQL batch or RPC events or the SQL
> script contained no SQL queries."
> I have tried from the query analyzer and from a workload trace file,
> in the 2 cases I receive the error.
> My query contain a join to a custom function which return a simple
> list. if I remove the function, then the index tuning works fine.
> my query:
> select * from table1 inner join dbo.MyFunction(@.Param) A on
> table1.ID = A.ID
> what can I do?
> thanks.
> Jerome.
You probably chose the wrong template for recording of events in profiler.
There is a template SQLProfilerTuning. It should work with that one.
Kind regards
robert|||I'm using standard templates which works fine with any query those with my
function.
but why I can't optimize from query analyzer?
"Robert Klemme" <bob.news@.gmx.net> wrote in message
news:e$XXF4wcFHA.2760@.tk2msftngp13.phx.gbl...
> Jj wrote:
> You probably chose the wrong template for recording of events in profiler.
> There is a template SQLProfilerTuning. It should work with that one.
> Kind regards
> robert
>
can't use the index tuning wizard wioth a function??
Hi,
I receive this error when I try to execute the index tuning wizard:
"There are no events in the workload. Either the trace
file contained no SQL batch or RPC events or the SQL
script contained no SQL queries."
I have tried from the query analyzer and from a workload trace file, in the
2 cases I receive the error.
My query contain a join to a custom function which return a simple list.
if I remove the function, then the index tuning works fine.
my query:
select * from table1 inner join dbo.MyFunction(@.Param) A on table1.ID = A.ID
what can I do?
thanks.
Jerome.Jéjé wrote:
> Hi,
> I receive this error when I try to execute the index tuning wizard:
> "There are no events in the workload. Either the trace
> file contained no SQL batch or RPC events or the SQL
> script contained no SQL queries."
> I have tried from the query analyzer and from a workload trace file,
> in the 2 cases I receive the error.
> My query contain a join to a custom function which return a simple
> list. if I remove the function, then the index tuning works fine.
> my query:
> select * from table1 inner join dbo.MyFunction(@.Param) A on
> table1.ID = A.ID
> what can I do?
> thanks.
> Jerome.
You probably chose the wrong template for recording of events in profiler.
There is a template SQLProfilerTuning. It should work with that one.
Kind regards
robert|||I'm using standard templates which works fine with any query those with my
function.
but why I can't optimize from query analyzer?
"Robert Klemme" <bob.news@.gmx.net> wrote in message
news:e$XXF4wcFHA.2760@.tk2msftngp13.phx.gbl...
> Jéjé wrote:
>> Hi,
>> I receive this error when I try to execute the index tuning wizard:
>> "There are no events in the workload. Either the trace
>> file contained no SQL batch or RPC events or the SQL
>> script contained no SQL queries."
>> I have tried from the query analyzer and from a workload trace file,
>> in the 2 cases I receive the error.
>> My query contain a join to a custom function which return a simple
>> list. if I remove the function, then the index tuning works fine.
>> my query:
>> select * from table1 inner join dbo.MyFunction(@.Param) A on
>> table1.ID = A.ID
>> what can I do?
>> thanks.
>> Jerome.
> You probably chose the wrong template for recording of events in profiler.
> There is a template SQLProfilerTuning. It should work with that one.
> Kind regards
> robert
>
I receive this error when I try to execute the index tuning wizard:
"There are no events in the workload. Either the trace
file contained no SQL batch or RPC events or the SQL
script contained no SQL queries."
I have tried from the query analyzer and from a workload trace file, in the
2 cases I receive the error.
My query contain a join to a custom function which return a simple list.
if I remove the function, then the index tuning works fine.
my query:
select * from table1 inner join dbo.MyFunction(@.Param) A on table1.ID = A.ID
what can I do?
thanks.
Jerome.Jéjé wrote:
> Hi,
> I receive this error when I try to execute the index tuning wizard:
> "There are no events in the workload. Either the trace
> file contained no SQL batch or RPC events or the SQL
> script contained no SQL queries."
> I have tried from the query analyzer and from a workload trace file,
> in the 2 cases I receive the error.
> My query contain a join to a custom function which return a simple
> list. if I remove the function, then the index tuning works fine.
> my query:
> select * from table1 inner join dbo.MyFunction(@.Param) A on
> table1.ID = A.ID
> what can I do?
> thanks.
> Jerome.
You probably chose the wrong template for recording of events in profiler.
There is a template SQLProfilerTuning. It should work with that one.
Kind regards
robert|||I'm using standard templates which works fine with any query those with my
function.
but why I can't optimize from query analyzer?
"Robert Klemme" <bob.news@.gmx.net> wrote in message
news:e$XXF4wcFHA.2760@.tk2msftngp13.phx.gbl...
> Jéjé wrote:
>> Hi,
>> I receive this error when I try to execute the index tuning wizard:
>> "There are no events in the workload. Either the trace
>> file contained no SQL batch or RPC events or the SQL
>> script contained no SQL queries."
>> I have tried from the query analyzer and from a workload trace file,
>> in the 2 cases I receive the error.
>> My query contain a join to a custom function which return a simple
>> list. if I remove the function, then the index tuning works fine.
>> my query:
>> select * from table1 inner join dbo.MyFunction(@.Param) A on
>> table1.ID = A.ID
>> what can I do?
>> thanks.
>> Jerome.
> You probably chose the wrong template for recording of events in profiler.
> There is a template SQLProfilerTuning. It should work with that one.
> Kind regards
> robert
>
Sunday, February 12, 2012
Can't Use "Transacional publication" Option (It's Grayed Out!)
Used the Wizard to Creat Publication for the first time.
I saw three choices "Snapshot publication", "Transacional publication"
and "Merge publication".
I wanted to slect "Transacional publication" but it was grayed out. I
wonder why!!
Created a database with one table on server A.
Created same database with same table on server B.
I'm making A the publisher/distributor and B the subscriber.
The Recovery Model for both database on both servers is 'Full' model.
I backed up a transaction log.
How can I get to select Publication using the 'Transaction' type?
Thank you very much
Mike
*** Sent via Developersdex http://www.codecomments.com ***
I suspect your SQL Server version is MSDE - transactional replication is not
supported on MSDE - upgrade to SQL Server standard.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"mike" <-nospam@.yahoo.com> wrote in message
news:OBwQbcz2FHA.3600@.TK2MSFTNGP12.phx.gbl...
> Used the Wizard to Creat Publication for the first time.
> I saw three choices "Snapshot publication", "Transacional publication"
> and "Merge publication".
> I wanted to slect "Transacional publication" but it was grayed out. I
> wonder why!!
> Created a database with one table on server A.
> Created same database with same table on server B.
> I'm making A the publisher/distributor and B the subscriber.
> The Recovery Model for both database on both servers is 'Full' model.
> I backed up a transaction log.
> How can I get to select Publication using the 'Transaction' type?
> Thank you very much
>
> Mike
> *** Sent via Developersdex http://www.codecomments.com ***
|||(...or Personal Edition).
Paul Ibison
I saw three choices "Snapshot publication", "Transacional publication"
and "Merge publication".
I wanted to slect "Transacional publication" but it was grayed out. I
wonder why!!
Created a database with one table on server A.
Created same database with same table on server B.
I'm making A the publisher/distributor and B the subscriber.
The Recovery Model for both database on both servers is 'Full' model.
I backed up a transaction log.
How can I get to select Publication using the 'Transaction' type?
Thank you very much
Mike
*** Sent via Developersdex http://www.codecomments.com ***
I suspect your SQL Server version is MSDE - transactional replication is not
supported on MSDE - upgrade to SQL Server standard.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"mike" <-nospam@.yahoo.com> wrote in message
news:OBwQbcz2FHA.3600@.TK2MSFTNGP12.phx.gbl...
> Used the Wizard to Creat Publication for the first time.
> I saw three choices "Snapshot publication", "Transacional publication"
> and "Merge publication".
> I wanted to slect "Transacional publication" but it was grayed out. I
> wonder why!!
> Created a database with one table on server A.
> Created same database with same table on server B.
> I'm making A the publisher/distributor and B the subscriber.
> The Recovery Model for both database on both servers is 'Full' model.
> I backed up a transaction log.
> How can I get to select Publication using the 'Transaction' type?
> Thank you very much
>
> Mike
> *** Sent via Developersdex http://www.codecomments.com ***
|||(...or Personal Edition).
Paul Ibison
Friday, February 10, 2012
Can't Uninstall 2005 Beta
I am trying to uninstall the beta version so I can install the CTP version.
I tried using the Cleanup Wizard that came with the CTP version but it errors
when trying to uninstall the beta version - says I have to use Add/Remove
programs.
But when I try to use Add/Remove programs, I get a message that says "the
..Net Framework 2.0 is not installed. Please install before running setup."
The 2.0 beta framework is installed.
How do I uninstall the beta SQL Server and all its components (reporting
services, notification services, etc.)?
Hi
Is the correct version of the 2.0 framework installed (the one that came
with your beta).
It is best to ask SQL Server 2005 Beta questions in the beta newsgroups as
MS will give support in those and not here.
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/
"Jason" <Jason@.discussions.microsoft.com> wrote in message
news:00C053BE-8CB5-4EB5-872C-68BBEC3D3CBB@.microsoft.com...
>I am trying to uninstall the beta version so I can install the CTP version.
> I tried using the Cleanup Wizard that came with the CTP version but it
> errors
> when trying to uninstall the beta version - says I have to use Add/Remove
> programs.
> But when I try to use Add/Remove programs, I get a message that says "the
> .Net Framework 2.0 is not installed. Please install before running
> setup."
> The 2.0 beta framework is installed.
> How do I uninstall the beta SQL Server and all its components (reporting
> services, notification services, etc.)?
|||thanks. what is the correct url to the beta group?
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Is the correct version of the 2.0 framework installed (the one that came
> with your beta).
> It is best to ask SQL Server 2005 Beta questions in the beta newsgroups as
> MS will give support in those and not here.
> 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/
> "Jason" <Jason@.discussions.microsoft.com> wrote in message
> news:00C053BE-8CB5-4EB5-872C-68BBEC3D3CBB@.microsoft.com...
>
>
|||http://communities.microsoft.com/new...=sqlserver2005
Have you read the readme file that comes with the Beta? Gives you all the
information there.
--
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/
"Jason" <Jason@.discussions.microsoft.com> wrote in message
news:D125FCE1-7F35-4082-9CF4-237637A1C4CB@.microsoft.com...[vbcol=seagreen]
> thanks. what is the correct url to the beta group?
> "Mike Epprecht (SQL MVP)" wrote:
I tried using the Cleanup Wizard that came with the CTP version but it errors
when trying to uninstall the beta version - says I have to use Add/Remove
programs.
But when I try to use Add/Remove programs, I get a message that says "the
..Net Framework 2.0 is not installed. Please install before running setup."
The 2.0 beta framework is installed.
How do I uninstall the beta SQL Server and all its components (reporting
services, notification services, etc.)?
Hi
Is the correct version of the 2.0 framework installed (the one that came
with your beta).
It is best to ask SQL Server 2005 Beta questions in the beta newsgroups as
MS will give support in those and not here.
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/
"Jason" <Jason@.discussions.microsoft.com> wrote in message
news:00C053BE-8CB5-4EB5-872C-68BBEC3D3CBB@.microsoft.com...
>I am trying to uninstall the beta version so I can install the CTP version.
> I tried using the Cleanup Wizard that came with the CTP version but it
> errors
> when trying to uninstall the beta version - says I have to use Add/Remove
> programs.
> But when I try to use Add/Remove programs, I get a message that says "the
> .Net Framework 2.0 is not installed. Please install before running
> setup."
> The 2.0 beta framework is installed.
> How do I uninstall the beta SQL Server and all its components (reporting
> services, notification services, etc.)?
|||thanks. what is the correct url to the beta group?
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Is the correct version of the 2.0 framework installed (the one that came
> with your beta).
> It is best to ask SQL Server 2005 Beta questions in the beta newsgroups as
> MS will give support in those and not here.
> 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/
> "Jason" <Jason@.discussions.microsoft.com> wrote in message
> news:00C053BE-8CB5-4EB5-872C-68BBEC3D3CBB@.microsoft.com...
>
>
|||http://communities.microsoft.com/new...=sqlserver2005
Have you read the readme file that comes with the Beta? Gives you all the
information there.
--
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/
"Jason" <Jason@.discussions.microsoft.com> wrote in message
news:D125FCE1-7F35-4082-9CF4-237637A1C4CB@.microsoft.com...[vbcol=seagreen]
> thanks. what is the correct url to the beta group?
> "Mike Epprecht (SQL MVP)" wrote:
Can't Uninstall 2005 Beta
I am trying to uninstall the beta version so I can install the CTP version.
I tried using the Cleanup Wizard that came with the CTP version but it error
s
when trying to uninstall the beta version - says I have to use Add/Remove
programs.
But when I try to use Add/Remove programs, I get a message that says "the
.Net Framework 2.0 is not installed. Please install before running setup."
The 2.0 beta framework is installed.
How do I uninstall the beta SQL Server and all its components (reporting
services, notification services, etc.)?Hi
Is the correct version of the 2.0 framework installed (the one that came
with your beta).
It is best to ask SQL Server 2005 Beta questions in the beta newsgroups as
MS will give support in those and not here.
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/
"Jason" <Jason@.discussions.microsoft.com> wrote in message
news:00C053BE-8CB5-4EB5-872C-68BBEC3D3CBB@.microsoft.com...
>I am trying to uninstall the beta version so I can install the CTP version.
> I tried using the Cleanup Wizard that came with the CTP version but it
> errors
> when trying to uninstall the beta version - says I have to use Add/Remove
> programs.
> But when I try to use Add/Remove programs, I get a message that says "the
> .Net Framework 2.0 is not installed. Please install before running
> setup."
> The 2.0 beta framework is installed.
> How do I uninstall the beta SQL Server and all its components (reporting
> services, notification services, etc.)?|||thanks. what is the correct url to the beta group?
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Is the correct version of the 2.0 framework installed (the one that came
> with your beta).
> It is best to ask SQL Server 2005 Beta questions in the beta newsgroups as
> MS will give support in those and not here.
> 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/
> "Jason" <Jason@.discussions.microsoft.com> wrote in message
> news:00C053BE-8CB5-4EB5-872C-68BBEC3D3CBB@.microsoft.com...
>
>|||http://communities.microsoft.com/ne...p=sqlserver2005
Have you read the readme file that comes with the Beta? Gives you all the
information there.
--
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/
"Jason" <Jason@.discussions.microsoft.com> wrote in message
news:D125FCE1-7F35-4082-9CF4-237637A1C4CB@.microsoft.com...[vbcol=seagreen]
> thanks. what is the correct url to the beta group?
> "Mike Epprecht (SQL MVP)" wrote:
>
I tried using the Cleanup Wizard that came with the CTP version but it error
s
when trying to uninstall the beta version - says I have to use Add/Remove
programs.
But when I try to use Add/Remove programs, I get a message that says "the
.Net Framework 2.0 is not installed. Please install before running setup."
The 2.0 beta framework is installed.
How do I uninstall the beta SQL Server and all its components (reporting
services, notification services, etc.)?Hi
Is the correct version of the 2.0 framework installed (the one that came
with your beta).
It is best to ask SQL Server 2005 Beta questions in the beta newsgroups as
MS will give support in those and not here.
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/
"Jason" <Jason@.discussions.microsoft.com> wrote in message
news:00C053BE-8CB5-4EB5-872C-68BBEC3D3CBB@.microsoft.com...
>I am trying to uninstall the beta version so I can install the CTP version.
> I tried using the Cleanup Wizard that came with the CTP version but it
> errors
> when trying to uninstall the beta version - says I have to use Add/Remove
> programs.
> But when I try to use Add/Remove programs, I get a message that says "the
> .Net Framework 2.0 is not installed. Please install before running
> setup."
> The 2.0 beta framework is installed.
> How do I uninstall the beta SQL Server and all its components (reporting
> services, notification services, etc.)?|||thanks. what is the correct url to the beta group?
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Is the correct version of the 2.0 framework installed (the one that came
> with your beta).
> It is best to ask SQL Server 2005 Beta questions in the beta newsgroups as
> MS will give support in those and not here.
> 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/
> "Jason" <Jason@.discussions.microsoft.com> wrote in message
> news:00C053BE-8CB5-4EB5-872C-68BBEC3D3CBB@.microsoft.com...
>
>|||http://communities.microsoft.com/ne...p=sqlserver2005
Have you read the readme file that comes with the Beta? Gives you all the
information there.
--
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/
"Jason" <Jason@.discussions.microsoft.com> wrote in message
news:D125FCE1-7F35-4082-9CF4-237637A1C4CB@.microsoft.com...[vbcol=seagreen]
> thanks. what is the correct url to the beta group?
> "Mike Epprecht (SQL MVP)" wrote:
>
Can't Uninstall 2005 Beta
I am trying to uninstall the beta version so I can install the CTP version.
I tried using the Cleanup Wizard that came with the CTP version but it errors
when trying to uninstall the beta version - says I have to use Add/Remove
programs.
But when I try to use Add/Remove programs, I get a message that says "the
.Net Framework 2.0 is not installed. Please install before running setup."
The 2.0 beta framework is installed.
How do I uninstall the beta SQL Server and all its components (reporting
services, notification services, etc.)?Hi
Is the correct version of the 2.0 framework installed (the one that came
with your beta).
It is best to ask SQL Server 2005 Beta questions in the beta newsgroups as
MS will give support in those and not here.
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/
"Jason" <Jason@.discussions.microsoft.com> wrote in message
news:00C053BE-8CB5-4EB5-872C-68BBEC3D3CBB@.microsoft.com...
>I am trying to uninstall the beta version so I can install the CTP version.
> I tried using the Cleanup Wizard that came with the CTP version but it
> errors
> when trying to uninstall the beta version - says I have to use Add/Remove
> programs.
> But when I try to use Add/Remove programs, I get a message that says "the
> .Net Framework 2.0 is not installed. Please install before running
> setup."
> The 2.0 beta framework is installed.
> How do I uninstall the beta SQL Server and all its components (reporting
> services, notification services, etc.)?|||thanks. what is the correct url to the beta group?
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Is the correct version of the 2.0 framework installed (the one that came
> with your beta).
> It is best to ask SQL Server 2005 Beta questions in the beta newsgroups as
> MS will give support in those and not here.
> 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/
> "Jason" <Jason@.discussions.microsoft.com> wrote in message
> news:00C053BE-8CB5-4EB5-872C-68BBEC3D3CBB@.microsoft.com...
> >I am trying to uninstall the beta version so I can install the CTP version.
> > I tried using the Cleanup Wizard that came with the CTP version but it
> > errors
> > when trying to uninstall the beta version - says I have to use Add/Remove
> > programs.
> >
> > But when I try to use Add/Remove programs, I get a message that says "the
> > .Net Framework 2.0 is not installed. Please install before running
> > setup."
> > The 2.0 beta framework is installed.
> >
> > How do I uninstall the beta SQL Server and all its components (reporting
> > services, notification services, etc.)?
>
>|||http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005
Have you read the readme file that comes with the Beta? Gives you all the
information there.
--
--
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/
"Jason" <Jason@.discussions.microsoft.com> wrote in message
news:D125FCE1-7F35-4082-9CF4-237637A1C4CB@.microsoft.com...
> thanks. what is the correct url to the beta group?
> "Mike Epprecht (SQL MVP)" wrote:
>> Hi
>> Is the correct version of the 2.0 framework installed (the one that came
>> with your beta).
>> It is best to ask SQL Server 2005 Beta questions in the beta newsgroups
>> as
>> MS will give support in those and not here.
>> 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/
>> "Jason" <Jason@.discussions.microsoft.com> wrote in message
>> news:00C053BE-8CB5-4EB5-872C-68BBEC3D3CBB@.microsoft.com...
>> >I am trying to uninstall the beta version so I can install the CTP
>> >version.
>> > I tried using the Cleanup Wizard that came with the CTP version but it
>> > errors
>> > when trying to uninstall the beta version - says I have to use
>> > Add/Remove
>> > programs.
>> >
>> > But when I try to use Add/Remove programs, I get a message that says
>> > "the
>> > .Net Framework 2.0 is not installed. Please install before running
>> > setup."
>> > The 2.0 beta framework is installed.
>> >
>> > How do I uninstall the beta SQL Server and all its components
>> > (reporting
>> > services, notification services, etc.)?
>>
I tried using the Cleanup Wizard that came with the CTP version but it errors
when trying to uninstall the beta version - says I have to use Add/Remove
programs.
But when I try to use Add/Remove programs, I get a message that says "the
.Net Framework 2.0 is not installed. Please install before running setup."
The 2.0 beta framework is installed.
How do I uninstall the beta SQL Server and all its components (reporting
services, notification services, etc.)?Hi
Is the correct version of the 2.0 framework installed (the one that came
with your beta).
It is best to ask SQL Server 2005 Beta questions in the beta newsgroups as
MS will give support in those and not here.
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/
"Jason" <Jason@.discussions.microsoft.com> wrote in message
news:00C053BE-8CB5-4EB5-872C-68BBEC3D3CBB@.microsoft.com...
>I am trying to uninstall the beta version so I can install the CTP version.
> I tried using the Cleanup Wizard that came with the CTP version but it
> errors
> when trying to uninstall the beta version - says I have to use Add/Remove
> programs.
> But when I try to use Add/Remove programs, I get a message that says "the
> .Net Framework 2.0 is not installed. Please install before running
> setup."
> The 2.0 beta framework is installed.
> How do I uninstall the beta SQL Server and all its components (reporting
> services, notification services, etc.)?|||thanks. what is the correct url to the beta group?
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Is the correct version of the 2.0 framework installed (the one that came
> with your beta).
> It is best to ask SQL Server 2005 Beta questions in the beta newsgroups as
> MS will give support in those and not here.
> 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/
> "Jason" <Jason@.discussions.microsoft.com> wrote in message
> news:00C053BE-8CB5-4EB5-872C-68BBEC3D3CBB@.microsoft.com...
> >I am trying to uninstall the beta version so I can install the CTP version.
> > I tried using the Cleanup Wizard that came with the CTP version but it
> > errors
> > when trying to uninstall the beta version - says I have to use Add/Remove
> > programs.
> >
> > But when I try to use Add/Remove programs, I get a message that says "the
> > .Net Framework 2.0 is not installed. Please install before running
> > setup."
> > The 2.0 beta framework is installed.
> >
> > How do I uninstall the beta SQL Server and all its components (reporting
> > services, notification services, etc.)?
>
>|||http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005
Have you read the readme file that comes with the Beta? Gives you all the
information there.
--
--
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/
"Jason" <Jason@.discussions.microsoft.com> wrote in message
news:D125FCE1-7F35-4082-9CF4-237637A1C4CB@.microsoft.com...
> thanks. what is the correct url to the beta group?
> "Mike Epprecht (SQL MVP)" wrote:
>> Hi
>> Is the correct version of the 2.0 framework installed (the one that came
>> with your beta).
>> It is best to ask SQL Server 2005 Beta questions in the beta newsgroups
>> as
>> MS will give support in those and not here.
>> 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/
>> "Jason" <Jason@.discussions.microsoft.com> wrote in message
>> news:00C053BE-8CB5-4EB5-872C-68BBEC3D3CBB@.microsoft.com...
>> >I am trying to uninstall the beta version so I can install the CTP
>> >version.
>> > I tried using the Cleanup Wizard that came with the CTP version but it
>> > errors
>> > when trying to uninstall the beta version - says I have to use
>> > Add/Remove
>> > programs.
>> >
>> > But when I try to use Add/Remove programs, I get a message that says
>> > "the
>> > .Net Framework 2.0 is not installed. Please install before running
>> > setup."
>> > The 2.0 beta framework is installed.
>> >
>> > How do I uninstall the beta SQL Server and all its components
>> > (reporting
>> > services, notification services, etc.)?
>>
Can't transfer user logins and password from 6.5 to 2000
I tried the upgrade wizard and I am getting this error:
"Unable to connect to the Export Server. Please verify that you are an NT
Administrator on that machine"
I am an NT Administrator on that box.
I also tried the script located
http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
but when I run it, it gives me alot of errors. Can anyone help me with any
suggestions. Thanks.
--
New SQL Server DBA
--
New SQL Server DBAI would just script them out, type in the passwords, and go on down the road
personally. Provided you don't have too many SQL Logins.
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>I tried the upgrade wizard and I am getting this error:
> "Unable to connect to the Export Server. Please verify that you are an NT
> Administrator on that machine"
> I am an NT Administrator on that box.
> I also tried the script located
> http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
> but when I run it, it gives me alot of errors. Can anyone help me with
> any
> suggestions. Thanks.
> --
> New SQL Server DBA
> --
> New SQL Server DBA|||What do you mean by trying in the password, how do I get the passwords since
they are encrypted? Thanks.
"ChrisR" wrote:
> I would just script them out, type in the passwords, and go on down the road
> personally. Provided you don't have too many SQL Logins.
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
> >I tried the upgrade wizard and I am getting this error:
> > "Unable to connect to the Export Server. Please verify that you are an NT
> > Administrator on that machine"
> >
> > I am an NT Administrator on that box.
> >
> > I also tried the script located
> > http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
> >
> > but when I run it, it gives me alot of errors. Can anyone help me with
> > any
> > suggestions. Thanks.
> > --
> > New SQL Server DBA
> >
> > --
> > New SQL Server DBA
>
>|||Script them out in encrypted form and use that same encrypted for when creating them in SQL2K (check
out the parameters for sp_addlogin). Also, see if the KB article that has sp_help_revlogin (search
for that word) has something you can use in order to facilitate the scripting of your current
logins.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:72B8DCD1-2758-4CFD-899E-120560CD14BA@.microsoft.com...
> What do you mean by trying in the password, how do I get the passwords since
> they are encrypted? Thanks.
> "ChrisR" wrote:
>> I would just script them out, type in the passwords, and go on down the road
>> personally. Provided you don't have too many SQL Logins.
>>
>> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
>> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>> >I tried the upgrade wizard and I am getting this error:
>> > "Unable to connect to the Export Server. Please verify that you are an NT
>> > Administrator on that machine"
>> >
>> > I am an NT Administrator on that box.
>> >
>> > I also tried the script located
>> > http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
>> >
>> > but when I run it, it gives me alot of errors. Can anyone help me with
>> > any
>> > suggestions. Thanks.
>> > --
>> > New SQL Server DBA
>> >
>> > --
>> > New SQL Server DBA
>>
"Unable to connect to the Export Server. Please verify that you are an NT
Administrator on that machine"
I am an NT Administrator on that box.
I also tried the script located
http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
but when I run it, it gives me alot of errors. Can anyone help me with any
suggestions. Thanks.
--
New SQL Server DBA
--
New SQL Server DBAI would just script them out, type in the passwords, and go on down the road
personally. Provided you don't have too many SQL Logins.
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>I tried the upgrade wizard and I am getting this error:
> "Unable to connect to the Export Server. Please verify that you are an NT
> Administrator on that machine"
> I am an NT Administrator on that box.
> I also tried the script located
> http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
> but when I run it, it gives me alot of errors. Can anyone help me with
> any
> suggestions. Thanks.
> --
> New SQL Server DBA
> --
> New SQL Server DBA|||What do you mean by trying in the password, how do I get the passwords since
they are encrypted? Thanks.
"ChrisR" wrote:
> I would just script them out, type in the passwords, and go on down the road
> personally. Provided you don't have too many SQL Logins.
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
> >I tried the upgrade wizard and I am getting this error:
> > "Unable to connect to the Export Server. Please verify that you are an NT
> > Administrator on that machine"
> >
> > I am an NT Administrator on that box.
> >
> > I also tried the script located
> > http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
> >
> > but when I run it, it gives me alot of errors. Can anyone help me with
> > any
> > suggestions. Thanks.
> > --
> > New SQL Server DBA
> >
> > --
> > New SQL Server DBA
>
>|||Script them out in encrypted form and use that same encrypted for when creating them in SQL2K (check
out the parameters for sp_addlogin). Also, see if the KB article that has sp_help_revlogin (search
for that word) has something you can use in order to facilitate the scripting of your current
logins.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:72B8DCD1-2758-4CFD-899E-120560CD14BA@.microsoft.com...
> What do you mean by trying in the password, how do I get the passwords since
> they are encrypted? Thanks.
> "ChrisR" wrote:
>> I would just script them out, type in the passwords, and go on down the road
>> personally. Provided you don't have too many SQL Logins.
>>
>> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
>> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>> >I tried the upgrade wizard and I am getting this error:
>> > "Unable to connect to the Export Server. Please verify that you are an NT
>> > Administrator on that machine"
>> >
>> > I am an NT Administrator on that box.
>> >
>> > I also tried the script located
>> > http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
>> >
>> > but when I run it, it gives me alot of errors. Can anyone help me with
>> > any
>> > suggestions. Thanks.
>> > --
>> > New SQL Server DBA
>> >
>> > --
>> > New SQL Server DBA
>>
Can't transfer user logins and password from 6.5 to 2000
I tried the upgrade wizard and I am getting this error:
"Unable to connect to the Export Server. Please verify that you are an NT
Administrator on that machine"
I am an NT Administrator on that box.
I also tried the script located
ead/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnu
m=10#099a55c7fbed5496" target="_blank">http://groups-beta.google.com/group...99a55c7fbed5496
but when I run it, it gives me alot of errors. Can anyone help me with any
suggestions. Thanks.
--
New SQL Server DBA
New SQL Server DBAI would just script them out, type in the passwords, and go on down the road
personally. Provided you don't have too many SQL Logins.
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>I tried the upgrade wizard and I am getting this error:
> "Unable to connect to the Export Server. Please verify that you are an NT
> Administrator on that machine"
> I am an NT Administrator on that box.
> I also tried the script located
> hread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&r
num=10#099a55c7fbed5496" target="_blank">http://groups-beta.google.com/group...99a55c7fbed5496
> but when I run it, it gives me alot of errors. Can anyone help me with
> any
> suggestions. Thanks.
> --
> New SQL Server DBA
> --
> New SQL Server DBA|||What do you mean by trying in the password, how do I get the passwords since
they are encrypted? Thanks.
"ChrisR" wrote:
> I would just script them out, type in the passwords, and go on down the ro
ad
> personally. Provided you don't have too many SQL Logins.
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>
>|||Script them out in encrypted form and use that same encrypted for when creat
ing them in SQL2K (check
out the parameters for sp_addlogin). Also, see if the KB article that has sp
_help_revlogin (search
for that word) has something you can use in order to facilitate the scriptin
g of your current
logins.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:72B8DCD1-2758-4CFD-899E-120560CD14BA@.microsoft.com...[vbcol=seagreen]
> What do you mean by trying in the password, how do I get the passwords sin
ce
> they are encrypted? Thanks.
> "ChrisR" wrote:
>
"Unable to connect to the Export Server. Please verify that you are an NT
Administrator on that machine"
I am an NT Administrator on that box.
I also tried the script located
ead/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnu
m=10#099a55c7fbed5496" target="_blank">http://groups-beta.google.com/group...99a55c7fbed5496
but when I run it, it gives me alot of errors. Can anyone help me with any
suggestions. Thanks.
--
New SQL Server DBA
New SQL Server DBAI would just script them out, type in the passwords, and go on down the road
personally. Provided you don't have too many SQL Logins.
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>I tried the upgrade wizard and I am getting this error:
> "Unable to connect to the Export Server. Please verify that you are an NT
> Administrator on that machine"
> I am an NT Administrator on that box.
> I also tried the script located
> hread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&r
num=10#099a55c7fbed5496" target="_blank">http://groups-beta.google.com/group...99a55c7fbed5496
> but when I run it, it gives me alot of errors. Can anyone help me with
> any
> suggestions. Thanks.
> --
> New SQL Server DBA
> --
> New SQL Server DBA|||What do you mean by trying in the password, how do I get the passwords since
they are encrypted? Thanks.
"ChrisR" wrote:
> I would just script them out, type in the passwords, and go on down the ro
ad
> personally. Provided you don't have too many SQL Logins.
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>
>|||Script them out in encrypted form and use that same encrypted for when creat
ing them in SQL2K (check
out the parameters for sp_addlogin). Also, see if the KB article that has sp
_help_revlogin (search
for that word) has something you can use in order to facilitate the scriptin
g of your current
logins.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:72B8DCD1-2758-4CFD-899E-120560CD14BA@.microsoft.com...[vbcol=seagreen]
> What do you mean by trying in the password, how do I get the passwords sin
ce
> they are encrypted? Thanks.
> "ChrisR" wrote:
>
Can't transfer user logins and password from 6.5 to 2000
I tried the upgrade wizard and I am getting this error:
"Unable to connect to the Export Server. Please verify that you are an NT
Administrator on that machine"
I am an NT Administrator on that box.
I also tried the script located
http://groups-beta.google.com/group/...9a55c7fbed5496
but when I run it, it gives me alot of errors. Can anyone help me with any
suggestions. Thanks.
New SQL Server DBA
New SQL Server DBA
I would just script them out, type in the passwords, and go on down the road
personally. Provided you don't have too many SQL Logins.
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>I tried the upgrade wizard and I am getting this error:
> "Unable to connect to the Export Server. Please verify that you are an NT
> Administrator on that machine"
> I am an NT Administrator on that box.
> I also tried the script located
> http://groups-beta.google.com/group/...9a55c7fbed5496
> but when I run it, it gives me alot of errors. Can anyone help me with
> any
> suggestions. Thanks.
> --
> New SQL Server DBA
> --
> New SQL Server DBA
|||What do you mean by trying in the password, how do I get the passwords since
they are encrypted? Thanks.
"ChrisR" wrote:
> I would just script them out, type in the passwords, and go on down the road
> personally. Provided you don't have too many SQL Logins.
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>
>
|||Script them out in encrypted form and use that same encrypted for when creating them in SQL2K (check
out the parameters for sp_addlogin). Also, see if the KB article that has sp_help_revlogin (search
for that word) has something you can use in order to facilitate the scripting of your current
logins.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:72B8DCD1-2758-4CFD-899E-120560CD14BA@.microsoft.com...[vbcol=seagreen]
> What do you mean by trying in the password, how do I get the passwords since
> they are encrypted? Thanks.
> "ChrisR" wrote:
"Unable to connect to the Export Server. Please verify that you are an NT
Administrator on that machine"
I am an NT Administrator on that box.
I also tried the script located
http://groups-beta.google.com/group/...9a55c7fbed5496
but when I run it, it gives me alot of errors. Can anyone help me with any
suggestions. Thanks.
New SQL Server DBA
New SQL Server DBA
I would just script them out, type in the passwords, and go on down the road
personally. Provided you don't have too many SQL Logins.
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>I tried the upgrade wizard and I am getting this error:
> "Unable to connect to the Export Server. Please verify that you are an NT
> Administrator on that machine"
> I am an NT Administrator on that box.
> I also tried the script located
> http://groups-beta.google.com/group/...9a55c7fbed5496
> but when I run it, it gives me alot of errors. Can anyone help me with
> any
> suggestions. Thanks.
> --
> New SQL Server DBA
> --
> New SQL Server DBA
|||What do you mean by trying in the password, how do I get the passwords since
they are encrypted? Thanks.
"ChrisR" wrote:
> I would just script them out, type in the passwords, and go on down the road
> personally. Provided you don't have too many SQL Logins.
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>
>
|||Script them out in encrypted form and use that same encrypted for when creating them in SQL2K (check
out the parameters for sp_addlogin). Also, see if the KB article that has sp_help_revlogin (search
for that word) has something you can use in order to facilitate the scripting of your current
logins.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:72B8DCD1-2758-4CFD-899E-120560CD14BA@.microsoft.com...[vbcol=seagreen]
> What do you mean by trying in the password, how do I get the passwords since
> they are encrypted? Thanks.
> "ChrisR" wrote:
Subscribe to:
Posts (Atom)