Hi.
Is there any simple way of copying all of the ssis packages between two
servers?
I have just installed sql 2005 on a new, better equipped machine and I have
to move there all the data. Including ssis of course. There are about 40-50
packages to do (stored in the database, not in filesystem) and I hope there
is a better way than just to import packages (one by one) to a text file
and export them to another server.
BTW, I'm going to copy the job definitions as well, there are about 20 jobs
defined on the server, is there any handy way of doing this? Any hints?
PLTry backing up and restoring MSDB and changing the appropriate fields.
We do this with jobs every week to keep 2 servers in sync and this is what
we use to bring the jobs up to date. I would imagine that it could be just
as easy for SSIS packages, though I haven't tried it officially.
UPDATE sysjobs
SET originating_server = 'MyServer'
So just run that on the new server once you have MSDB restored on there and
you should be OK. And just check the SSIS tables to discover similar entrie
s
that may need to be changed.
"Piotr Lipski" wrote:
> Hi.
> Is there any simple way of copying all of the ssis packages between two
> servers?
> I have just installed sql 2005 on a new, better equipped machine and I hav
e
> to move there all the data. Including ssis of course. There are about 40-5
0
> packages to do (stored in the database, not in filesystem) and I hope ther
e
> is a better way than just to import packages (one by one) to a text file
> and export them to another server.
> BTW, I'm going to copy the job definitions as well, there are about 20 job
s
> defined on the server, is there any handy way of doing this? Any hints?
> --
> PL
>|||Sean McCown wrote:
> Try backing up and restoring MSDB and changing the appropriate fields.
> We do this with jobs every week to keep 2 servers in sync and this is what
> we use to bring the jobs up to date. I would imagine that it could be jus
t
> as easy for SSIS packages, though I haven't tried it officially.
> UPDATE sysjobs
> SET originating_server = 'MyServer'
> So just run that on the new server once you have MSDB restored on there an
d
> you should be OK. And just check the SSIS tables to discover similar entr
ies
> that may need to be changed.
Right. But how to restore the msdb database? When I try to do it from
SMS (right click on database -> tasks -> restore) I get failure message
"Exclusive access could not be obtained because the database is in
use.", which makes sense but does not resolve the problem. There is also
no option to go off-line or detach for that database.
Should I just replace the msdb datafiles (mdf/ldf) with the ones from
'old' server?
PL|||OK, there are a couple things here...
first, to restore MSDB just startup SQL with -T3608 and -m. 3608 prevents
startup of all system DBs except master. -m is single-user mode. So you
should now be able to restore MSDB with no problem. If you're doing it from
the command line, then use -c.
Second, You can always just setup a linked server and copy the raw data over
without restoring.
Good luck.
"Piotr Lipski" wrote:
> Sean McCown wrote:
> Right. But how to restore the msdb database? When I try to do it from
> SMS (right click on database -> tasks -> restore) I get failure message
> "Exclusive access could not be obtained because the database is in
> use.", which makes sense but does not resolve the problem. There is also
> no option to go off-line or detach for that database.
> Should I just replace the msdb datafiles (mdf/ldf) with the ones from
> 'old' server?
> --
> PL
>
Showing posts with label installed. Show all posts
Showing posts with label installed. Show all posts
Thursday, March 29, 2012
copy many ssis packages between servers
Hi.
Is there any simple way of copying all of the ssis packages between two
servers?
I have just installed sql 2005 on a new, better equipped machine and I have
to move there all the data. Including ssis of course. There are about 40-50
packages to do (stored in the database, not in filesystem) and I hope there
is a better way than just to import packages (one by one) to a text file
and export them to another server.
BTW, I'm going to copy the job definitions as well, there are about 20 jobs
defined on the server, is there any handy way of doing this? Any hints?
--
PLTry backing up and restoring MSDB and changing the appropriate fields.
We do this with jobs every week to keep 2 servers in sync and this is what
we use to bring the jobs up to date. I would imagine that it could be just
as easy for SSIS packages, though I haven't tried it officially.
UPDATE sysjobs
SET originating_server = 'MyServer'
So just run that on the new server once you have MSDB restored on there and
you should be OK. And just check the SSIS tables to discover similar entries
that may need to be changed.
"Piotr Lipski" wrote:
> Hi.
> Is there any simple way of copying all of the ssis packages between two
> servers?
> I have just installed sql 2005 on a new, better equipped machine and I have
> to move there all the data. Including ssis of course. There are about 40-50
> packages to do (stored in the database, not in filesystem) and I hope there
> is a better way than just to import packages (one by one) to a text file
> and export them to another server.
> BTW, I'm going to copy the job definitions as well, there are about 20 jobs
> defined on the server, is there any handy way of doing this? Any hints?
> --
> PL
>|||Sean McCown wrote:
> Try backing up and restoring MSDB and changing the appropriate fields.
> We do this with jobs every week to keep 2 servers in sync and this is what
> we use to bring the jobs up to date. I would imagine that it could be just
> as easy for SSIS packages, though I haven't tried it officially.
> UPDATE sysjobs
> SET originating_server = 'MyServer'
> So just run that on the new server once you have MSDB restored on there and
> you should be OK. And just check the SSIS tables to discover similar entries
> that may need to be changed.
Right. But how to restore the msdb database? When I try to do it from
SMS (right click on database -> tasks -> restore) I get failure message
"Exclusive access could not be obtained because the database is in
use.", which makes sense but does not resolve the problem. There is also
no option to go off-line or detach for that database.
Should I just replace the msdb datafiles (mdf/ldf) with the ones from
'old' server?
--
PL|||OK, there are a couple things here...
first, to restore MSDB just startup SQL with -T3608 and -m. 3608 prevents
startup of all system DBs except master. -m is single-user mode. So you
should now be able to restore MSDB with no problem. If you're doing it from
the command line, then use -c.
Second, You can always just setup a linked server and copy the raw data over
without restoring.
Good luck.
"Piotr Lipski" wrote:
> Sean McCown wrote:
> > Try backing up and restoring MSDB and changing the appropriate fields.
> > We do this with jobs every week to keep 2 servers in sync and this is what
> > we use to bring the jobs up to date. I would imagine that it could be just
> > as easy for SSIS packages, though I haven't tried it officially.
> >
> > UPDATE sysjobs
> > SET originating_server = 'MyServer'
> >
> > So just run that on the new server once you have MSDB restored on there and
> > you should be OK. And just check the SSIS tables to discover similar entries
> > that may need to be changed.
> Right. But how to restore the msdb database? When I try to do it from
> SMS (right click on database -> tasks -> restore) I get failure message
> "Exclusive access could not be obtained because the database is in
> use.", which makes sense but does not resolve the problem. There is also
> no option to go off-line or detach for that database.
> Should I just replace the msdb datafiles (mdf/ldf) with the ones from
> 'old' server?
> --
> PL
>
Is there any simple way of copying all of the ssis packages between two
servers?
I have just installed sql 2005 on a new, better equipped machine and I have
to move there all the data. Including ssis of course. There are about 40-50
packages to do (stored in the database, not in filesystem) and I hope there
is a better way than just to import packages (one by one) to a text file
and export them to another server.
BTW, I'm going to copy the job definitions as well, there are about 20 jobs
defined on the server, is there any handy way of doing this? Any hints?
--
PLTry backing up and restoring MSDB and changing the appropriate fields.
We do this with jobs every week to keep 2 servers in sync and this is what
we use to bring the jobs up to date. I would imagine that it could be just
as easy for SSIS packages, though I haven't tried it officially.
UPDATE sysjobs
SET originating_server = 'MyServer'
So just run that on the new server once you have MSDB restored on there and
you should be OK. And just check the SSIS tables to discover similar entries
that may need to be changed.
"Piotr Lipski" wrote:
> Hi.
> Is there any simple way of copying all of the ssis packages between two
> servers?
> I have just installed sql 2005 on a new, better equipped machine and I have
> to move there all the data. Including ssis of course. There are about 40-50
> packages to do (stored in the database, not in filesystem) and I hope there
> is a better way than just to import packages (one by one) to a text file
> and export them to another server.
> BTW, I'm going to copy the job definitions as well, there are about 20 jobs
> defined on the server, is there any handy way of doing this? Any hints?
> --
> PL
>|||Sean McCown wrote:
> Try backing up and restoring MSDB and changing the appropriate fields.
> We do this with jobs every week to keep 2 servers in sync and this is what
> we use to bring the jobs up to date. I would imagine that it could be just
> as easy for SSIS packages, though I haven't tried it officially.
> UPDATE sysjobs
> SET originating_server = 'MyServer'
> So just run that on the new server once you have MSDB restored on there and
> you should be OK. And just check the SSIS tables to discover similar entries
> that may need to be changed.
Right. But how to restore the msdb database? When I try to do it from
SMS (right click on database -> tasks -> restore) I get failure message
"Exclusive access could not be obtained because the database is in
use.", which makes sense but does not resolve the problem. There is also
no option to go off-line or detach for that database.
Should I just replace the msdb datafiles (mdf/ldf) with the ones from
'old' server?
--
PL|||OK, there are a couple things here...
first, to restore MSDB just startup SQL with -T3608 and -m. 3608 prevents
startup of all system DBs except master. -m is single-user mode. So you
should now be able to restore MSDB with no problem. If you're doing it from
the command line, then use -c.
Second, You can always just setup a linked server and copy the raw data over
without restoring.
Good luck.
"Piotr Lipski" wrote:
> Sean McCown wrote:
> > Try backing up and restoring MSDB and changing the appropriate fields.
> > We do this with jobs every week to keep 2 servers in sync and this is what
> > we use to bring the jobs up to date. I would imagine that it could be just
> > as easy for SSIS packages, though I haven't tried it officially.
> >
> > UPDATE sysjobs
> > SET originating_server = 'MyServer'
> >
> > So just run that on the new server once you have MSDB restored on there and
> > you should be OK. And just check the SSIS tables to discover similar entries
> > that may need to be changed.
> Right. But how to restore the msdb database? When I try to do it from
> SMS (right click on database -> tasks -> restore) I get failure message
> "Exclusive access could not be obtained because the database is in
> use.", which makes sense but does not resolve the problem. There is also
> no option to go off-line or detach for that database.
> Should I just replace the msdb datafiles (mdf/ldf) with the ones from
> 'old' server?
> --
> PL
>
copy many ssis packages between servers
Hi.
Is there any simple way of copying all of the ssis packages between two
servers?
I have just installed sql 2005 on a new, better equipped machine and I have
to move there all the data. Including ssis of course. There are about 40-50
packages to do (stored in the database, not in filesystem) and I hope there
is a better way than just to import packages (one by one) to a text file
and export them to another server.
BTW, I'm going to copy the job definitions as well, there are about 20 jobs
defined on the server, is there any handy way of doing this? Any hints?
PL
Try backing up and restoring MSDB and changing the appropriate fields.
We do this with jobs every week to keep 2 servers in sync and this is what
we use to bring the jobs up to date. I would imagine that it could be just
as easy for SSIS packages, though I haven't tried it officially.
UPDATE sysjobs
SET originating_server = 'MyServer'
So just run that on the new server once you have MSDB restored on there and
you should be OK. And just check the SSIS tables to discover similar entries
that may need to be changed.
"Piotr Lipski" wrote:
> Hi.
> Is there any simple way of copying all of the ssis packages between two
> servers?
> I have just installed sql 2005 on a new, better equipped machine and I have
> to move there all the data. Including ssis of course. There are about 40-50
> packages to do (stored in the database, not in filesystem) and I hope there
> is a better way than just to import packages (one by one) to a text file
> and export them to another server.
> BTW, I'm going to copy the job definitions as well, there are about 20 jobs
> defined on the server, is there any handy way of doing this? Any hints?
> --
> PL
>
|||Sean McCown wrote:
> Try backing up and restoring MSDB and changing the appropriate fields.
> We do this with jobs every week to keep 2 servers in sync and this is what
> we use to bring the jobs up to date. I would imagine that it could be just
> as easy for SSIS packages, though I haven't tried it officially.
> UPDATE sysjobs
> SET originating_server = 'MyServer'
> So just run that on the new server once you have MSDB restored on there and
> you should be OK. And just check the SSIS tables to discover similar entries
> that may need to be changed.
Right. But how to restore the msdb database? When I try to do it from
SMS (right click on database -> tasks -> restore) I get failure message
"Exclusive access could not be obtained because the database is in
use.", which makes sense but does not resolve the problem. There is also
no option to go off-line or detach for that database.
Should I just replace the msdb datafiles (mdf/ldf) with the ones from
'old' server?
PL
|||OK, there are a couple things here...
first, to restore MSDB just startup SQL with -T3608 and -m. 3608 prevents
startup of all system DBs except master. -m is single-user mode. So you
should now be able to restore MSDB with no problem. If you're doing it from
the command line, then use -c.
Second, You can always just setup a linked server and copy the raw data over
without restoring.
Good luck.
"Piotr Lipski" wrote:
> Sean McCown wrote:
> Right. But how to restore the msdb database? When I try to do it from
> SMS (right click on database -> tasks -> restore) I get failure message
> "Exclusive access could not be obtained because the database is in
> use.", which makes sense but does not resolve the problem. There is also
> no option to go off-line or detach for that database.
> Should I just replace the msdb datafiles (mdf/ldf) with the ones from
> 'old' server?
> --
> PL
>
sqlsql
Is there any simple way of copying all of the ssis packages between two
servers?
I have just installed sql 2005 on a new, better equipped machine and I have
to move there all the data. Including ssis of course. There are about 40-50
packages to do (stored in the database, not in filesystem) and I hope there
is a better way than just to import packages (one by one) to a text file
and export them to another server.
BTW, I'm going to copy the job definitions as well, there are about 20 jobs
defined on the server, is there any handy way of doing this? Any hints?
PL
Try backing up and restoring MSDB and changing the appropriate fields.
We do this with jobs every week to keep 2 servers in sync and this is what
we use to bring the jobs up to date. I would imagine that it could be just
as easy for SSIS packages, though I haven't tried it officially.
UPDATE sysjobs
SET originating_server = 'MyServer'
So just run that on the new server once you have MSDB restored on there and
you should be OK. And just check the SSIS tables to discover similar entries
that may need to be changed.
"Piotr Lipski" wrote:
> Hi.
> Is there any simple way of copying all of the ssis packages between two
> servers?
> I have just installed sql 2005 on a new, better equipped machine and I have
> to move there all the data. Including ssis of course. There are about 40-50
> packages to do (stored in the database, not in filesystem) and I hope there
> is a better way than just to import packages (one by one) to a text file
> and export them to another server.
> BTW, I'm going to copy the job definitions as well, there are about 20 jobs
> defined on the server, is there any handy way of doing this? Any hints?
> --
> PL
>
|||Sean McCown wrote:
> Try backing up and restoring MSDB and changing the appropriate fields.
> We do this with jobs every week to keep 2 servers in sync and this is what
> we use to bring the jobs up to date. I would imagine that it could be just
> as easy for SSIS packages, though I haven't tried it officially.
> UPDATE sysjobs
> SET originating_server = 'MyServer'
> So just run that on the new server once you have MSDB restored on there and
> you should be OK. And just check the SSIS tables to discover similar entries
> that may need to be changed.
Right. But how to restore the msdb database? When I try to do it from
SMS (right click on database -> tasks -> restore) I get failure message
"Exclusive access could not be obtained because the database is in
use.", which makes sense but does not resolve the problem. There is also
no option to go off-line or detach for that database.
Should I just replace the msdb datafiles (mdf/ldf) with the ones from
'old' server?
PL
|||OK, there are a couple things here...
first, to restore MSDB just startup SQL with -T3608 and -m. 3608 prevents
startup of all system DBs except master. -m is single-user mode. So you
should now be able to restore MSDB with no problem. If you're doing it from
the command line, then use -c.
Second, You can always just setup a linked server and copy the raw data over
without restoring.
Good luck.
"Piotr Lipski" wrote:
> Sean McCown wrote:
> Right. But how to restore the msdb database? When I try to do it from
> SMS (right click on database -> tasks -> restore) I get failure message
> "Exclusive access could not be obtained because the database is in
> use.", which makes sense but does not resolve the problem. There is also
> no option to go off-line or detach for that database.
> Should I just replace the msdb datafiles (mdf/ldf) with the ones from
> 'old' server?
> --
> PL
>
sqlsql
Thursday, March 22, 2012
Copy Database Wizard on Vista x64 machine
I've got a new Vista x64 build with SQL2005 (+SP2) freshly installed. I'm
now trying to copy existing databased from other services but I can't get it
to work. I get the following error logged in the Event Viewer Application
Log:
"Log Name: Application
Source: Application Error
Date: 29/11/2007 16:16:56
Event ID: 1000
Task Category: (100)
Level: Error
Keywords: Classic
User: N/A
Computer: mycomputer
Description:
The description for Event ID 1000 from source Application Error cannot be
found. Either the component that raises this event is not installed on your
local computer or the installation is corrupted. You can install or repair
the component on the local computer.
If the event originated on another computer, the display information had to
be saved with the event.
The following information was included with the event:
DTExec.exe
2005.90.3042.0
45cd7539
kernel32.dll
6.0.6000.16386
4549d328
e053534f
00000000000233ac
The substitution string for insert index (%1) could not be found"
I cant find anything online that enlightens me - I know that Vista needs SP
installed to work, so I've installed it:
@.@.Version=
Microsoft SQL Server 2005 - 9.00.3054.00 (X64)
Mar 23 2007 18:41:50
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition (64-bit) on Windows NT 6.0 (Build 6000: )
All the services are running under a domain user that has access to the
areas where the data is stored, both source and destination, so I'm hoping
it's not a permissions issue - if it is, I wouldnt know where to look.
I *could* copy a local database to the same server (renamed of course), so
it suggests that the server is largely OK - does this suggest it *is* a
permissions issue?
The domain user that the services are running under are not in the local
Administrators group, but they are in the
SQLServer2005MSSQLUser$MyComputer$MSSQLS
ERVER group - which I assume is the
group that was set up by the SQL Server Provisioning Tool for Vista.
This is a development machine so I frequently want to copy different
versions of different databases backwards and forwards.
Any suggestions? Any other Vista x64-ers out there?
Thanks in advance...
ChrisSQL Server uses Active Directory accounts and groups for its
permissions.
Active Directory accounts and groups are represented by GUIDs that are
unique to a particular Active Directory Domain which is run by a
Primary Domain Contoroller. If your new Vista machine is not part of
a network, or is on a different domain than the old one, then it
probably uses different GUIDs for the active directory accounts than
the source machine did. If you copied over the SQL Server database
using a backup, then you probably also copied all the old GUIDs for
the SQL Server accounts that point to the GUIDs on the old machine,
and not the ones on new machine.
This means that your SQL Server accounts are out of sync with active
directory. you may have to recreate your SQL Server accounts on the
new machine.
Permissions are assigned through SQL Server Management Studio in two
steps. First, you assign the active directory accounts that are
allowed to connect to a SQL Server instance. This is done by right
clicking the Logins folder under the Security folder of the SQL Server
instance the user is to connect to and selecting New Login.
Then, you assign what SQL Server instance users are allowed to connect
to a particular database within an instance. This is done by right
clicking the Security folder under the database you want to give
permission for and selecting New->user.
In both cases, an extensive permissions dialog will open. For the
Login folder, you only have to specify an active directory account.
For the Security folder, you have to click securables in the left
sidebar, add the entities you want to view (tables), and then set
select, reference, update, delete, and insert permissions. There are
more steps, but this should point you in the right direction.|||Andy, thanks for your reply...
"Andy" <anedza@.infotek-consulting.com> wrote in message
news:1ee305c9-338f-4a4f-9a42-198b42c597b5@.w40g2000hsb.googlegroups.com...
> If your new Vista machine is not part of
> a network, or is on a different domain than the old one,
>
My new machine is part of the same Domain and is recognised within Active
Directory.
> Permissions are assigned through SQL Server Management Studio in two
> steps. First, you assign the active directory accounts that are
> allowed to connect to a SQL Server instance. This is done by right
> clicking the Logins folder under the Security folder of the SQL Server
> instance the user is to connect to and selecting New Login.
Each human administrator is per of an SQL Admins group as are each of the
domain users that the different servers run under. On each server, the SQL
Admins group is added with a login and has sufficiend permissions (AFAIK).
> Then, you assign what SQL Server instance users are allowed to connect
> to a particular database within an instance. This is done by right
> clicking the Security folder under the database you want to give
> permission for and selecting New->user.
>
Done
> In both cases, an extensive permissions dialog will open. For the
> Login folder, you only have to specify an active directory account.
> For the Security folder, you have to click securables in the left
> sidebar, add the entities you want to view (tables), and then set
> select, reference, update, delete, and insert permissions. There are
> more steps, but this should point you in the right direction.
>
The login is set as a sysdamin so surely this shouldnt be necessary?
Somewhere in my tweaking, I've changed something. I *think* it's for the
better - I'm still getting errors but I'm getting further along.
I'm now getting Error 12550: Access to the path
'\\MyServer\MyShare\MyDB.mdf' is denied. The SQL Admins group has read/write
permissions to this area so I'm puzzled.
This is immediately followed by another Error 12550: Object reference not
set to an instance of an object. There are other errors further on, but I
think they are just as a consequence of these earlier errors.
I'm actually going to start copying backups because I need to crack on with
things, but I'm determined to get to the bottom of this. In my work, this
wizard is very useful so I'd rather not have to work around it.
Any further ideas?
Cheers
Chris
now trying to copy existing databased from other services but I can't get it
to work. I get the following error logged in the Event Viewer Application
Log:
"Log Name: Application
Source: Application Error
Date: 29/11/2007 16:16:56
Event ID: 1000
Task Category: (100)
Level: Error
Keywords: Classic
User: N/A
Computer: mycomputer
Description:
The description for Event ID 1000 from source Application Error cannot be
found. Either the component that raises this event is not installed on your
local computer or the installation is corrupted. You can install or repair
the component on the local computer.
If the event originated on another computer, the display information had to
be saved with the event.
The following information was included with the event:
DTExec.exe
2005.90.3042.0
45cd7539
kernel32.dll
6.0.6000.16386
4549d328
e053534f
00000000000233ac
The substitution string for insert index (%1) could not be found"
I cant find anything online that enlightens me - I know that Vista needs SP
installed to work, so I've installed it:
@.@.Version=
Microsoft SQL Server 2005 - 9.00.3054.00 (X64)
Mar 23 2007 18:41:50
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition (64-bit) on Windows NT 6.0 (Build 6000: )
All the services are running under a domain user that has access to the
areas where the data is stored, both source and destination, so I'm hoping
it's not a permissions issue - if it is, I wouldnt know where to look.
I *could* copy a local database to the same server (renamed of course), so
it suggests that the server is largely OK - does this suggest it *is* a
permissions issue?
The domain user that the services are running under are not in the local
Administrators group, but they are in the
SQLServer2005MSSQLUser$MyComputer$MSSQLS
ERVER group - which I assume is the
group that was set up by the SQL Server Provisioning Tool for Vista.
This is a development machine so I frequently want to copy different
versions of different databases backwards and forwards.
Any suggestions? Any other Vista x64-ers out there?
Thanks in advance...
ChrisSQL Server uses Active Directory accounts and groups for its
permissions.
Active Directory accounts and groups are represented by GUIDs that are
unique to a particular Active Directory Domain which is run by a
Primary Domain Contoroller. If your new Vista machine is not part of
a network, or is on a different domain than the old one, then it
probably uses different GUIDs for the active directory accounts than
the source machine did. If you copied over the SQL Server database
using a backup, then you probably also copied all the old GUIDs for
the SQL Server accounts that point to the GUIDs on the old machine,
and not the ones on new machine.
This means that your SQL Server accounts are out of sync with active
directory. you may have to recreate your SQL Server accounts on the
new machine.
Permissions are assigned through SQL Server Management Studio in two
steps. First, you assign the active directory accounts that are
allowed to connect to a SQL Server instance. This is done by right
clicking the Logins folder under the Security folder of the SQL Server
instance the user is to connect to and selecting New Login.
Then, you assign what SQL Server instance users are allowed to connect
to a particular database within an instance. This is done by right
clicking the Security folder under the database you want to give
permission for and selecting New->user.
In both cases, an extensive permissions dialog will open. For the
Login folder, you only have to specify an active directory account.
For the Security folder, you have to click securables in the left
sidebar, add the entities you want to view (tables), and then set
select, reference, update, delete, and insert permissions. There are
more steps, but this should point you in the right direction.|||Andy, thanks for your reply...
"Andy" <anedza@.infotek-consulting.com> wrote in message
news:1ee305c9-338f-4a4f-9a42-198b42c597b5@.w40g2000hsb.googlegroups.com...
> If your new Vista machine is not part of
> a network, or is on a different domain than the old one,
>
My new machine is part of the same Domain and is recognised within Active
Directory.
> Permissions are assigned through SQL Server Management Studio in two
> steps. First, you assign the active directory accounts that are
> allowed to connect to a SQL Server instance. This is done by right
> clicking the Logins folder under the Security folder of the SQL Server
> instance the user is to connect to and selecting New Login.
Each human administrator is per of an SQL Admins group as are each of the
domain users that the different servers run under. On each server, the SQL
Admins group is added with a login and has sufficiend permissions (AFAIK).
> Then, you assign what SQL Server instance users are allowed to connect
> to a particular database within an instance. This is done by right
> clicking the Security folder under the database you want to give
> permission for and selecting New->user.
>
Done
> In both cases, an extensive permissions dialog will open. For the
> Login folder, you only have to specify an active directory account.
> For the Security folder, you have to click securables in the left
> sidebar, add the entities you want to view (tables), and then set
> select, reference, update, delete, and insert permissions. There are
> more steps, but this should point you in the right direction.
>
The login is set as a sysdamin so surely this shouldnt be necessary?
Somewhere in my tweaking, I've changed something. I *think* it's for the
better - I'm still getting errors but I'm getting further along.
I'm now getting Error 12550: Access to the path
'\\MyServer\MyShare\MyDB.mdf' is denied. The SQL Admins group has read/write
permissions to this area so I'm puzzled.
This is immediately followed by another Error 12550: Object reference not
set to an instance of an object. There are other errors further on, but I
think they are just as a consequence of these earlier errors.
I'm actually going to start copying backups because I need to crack on with
things, but I'm determined to get to the bottom of this. In my work, this
wizard is very useful so I'd rather not have to work around it.
Any further ideas?
Cheers
Chris
Copy Database Wizard on Vista x64 machine
I've got a new Vista x64 build with SQL2005 (+SP2) freshly installed. I'm
now trying to copy existing databased from other services but I can't get it
to work. I get the following error logged in the Event Viewer Application
Log:
"Log Name: Application
Source: Application Error
Date: 29/11/2007 16:16:56
Event ID: 1000
Task Category: (100)
Level: Error
Keywords: Classic
User: N/A
Computer: mycomputer
Description:
The description for Event ID 1000 from source Application Error cannot be
found. Either the component that raises this event is not installed on your
local computer or the installation is corrupted. You can install or repair
the component on the local computer.
If the event originated on another computer, the display information had to
be saved with the event.
The following information was included with the event:
DTExec.exe
2005.90.3042.0
45cd7539
kernel32.dll
6.0.6000.16386
4549d328
e053534f
00000000000233ac
The substitution string for insert index (%1) could not be found"
I cant find anything online that enlightens me - I know that Vista needs SP
installed to work, so I've installed it:
@.@.Version= Microsoft SQL Server 2005 - 9.00.3054.00 (X64)
Mar 23 2007 18:41:50
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition (64-bit) on Windows NT 6.0 (Build 6000: )
All the services are running under a domain user that has access to the
areas where the data is stored, both source and destination, so I'm hoping
it's not a permissions issue - if it is, I wouldnt know where to look.
I *could* copy a local database to the same server (renamed of course), so
it suggests that the server is largely OK - does this suggest it *is* a
permissions issue?
The domain user that the services are running under are not in the local
Administrators group, but they are in the
SQLServer2005MSSQLUser$MyComputer$MSSQLSERVER group - which I assume is the
group that was set up by the SQL Server Provisioning Tool for Vista.
This is a development machine so I frequently want to copy different
versions of different databases backwards and forwards.
Any suggestions? Any other Vista x64-ers out there?
Thanks in advance...
ChrisSQL Server uses Active Directory accounts and groups for its
permissions.
Active Directory accounts and groups are represented by GUIDs that are
unique to a particular Active Directory Domain which is run by a
Primary Domain Contoroller. If your new Vista machine is not part of
a network, or is on a different domain than the old one, then it
probably uses different GUIDs for the active directory accounts than
the source machine did. If you copied over the SQL Server database
using a backup, then you probably also copied all the old GUIDs for
the SQL Server accounts that point to the GUIDs on the old machine,
and not the ones on new machine.
This means that your SQL Server accounts are out of sync with active
directory. you may have to recreate your SQL Server accounts on the
new machine.
Permissions are assigned through SQL Server Management Studio in two
steps. First, you assign the active directory accounts that are
allowed to connect to a SQL Server instance. This is done by right
clicking the Logins folder under the Security folder of the SQL Server
instance the user is to connect to and selecting New Login.
Then, you assign what SQL Server instance users are allowed to connect
to a particular database within an instance. This is done by right
clicking the Security folder under the database you want to give
permission for and selecting New->user.
In both cases, an extensive permissions dialog will open. For the
Login folder, you only have to specify an active directory account.
For the Security folder, you have to click securables in the left
sidebar, add the entities you want to view (tables), and then set
select, reference, update, delete, and insert permissions. There are
more steps, but this should point you in the right direction.|||Andy, thanks for your reply...
"Andy" <anedza@.infotek-consulting.com> wrote in message
news:1ee305c9-338f-4a4f-9a42-198b42c597b5@.w40g2000hsb.googlegroups.com...
> If your new Vista machine is not part of
> a network, or is on a different domain than the old one,
>
My new machine is part of the same Domain and is recognised within Active
Directory.
> Permissions are assigned through SQL Server Management Studio in two
> steps. First, you assign the active directory accounts that are
> allowed to connect to a SQL Server instance. This is done by right
> clicking the Logins folder under the Security folder of the SQL Server
> instance the user is to connect to and selecting New Login.
Each human administrator is per of an SQL Admins group as are each of the
domain users that the different servers run under. On each server, the SQL
Admins group is added with a login and has sufficiend permissions (AFAIK).
> Then, you assign what SQL Server instance users are allowed to connect
> to a particular database within an instance. This is done by right
> clicking the Security folder under the database you want to give
> permission for and selecting New->user.
>
Done
> In both cases, an extensive permissions dialog will open. For the
> Login folder, you only have to specify an active directory account.
> For the Security folder, you have to click securables in the left
> sidebar, add the entities you want to view (tables), and then set
> select, reference, update, delete, and insert permissions. There are
> more steps, but this should point you in the right direction.
>
The login is set as a sysdamin so surely this shouldnt be necessary?
Somewhere in my tweaking, I've changed something. I *think* it's for the
better - I'm still getting errors but I'm getting further along.
I'm now getting Error 12550: Access to the path
'\\MyServer\MyShare\MyDB.mdf' is denied. The SQL Admins group has read/write
permissions to this area so I'm puzzled.
This is immediately followed by another Error 12550: Object reference not
set to an instance of an object. There are other errors further on, but I
think they are just as a consequence of these earlier errors.
I'm actually going to start copying backups because I need to crack on with
things, but I'm determined to get to the bottom of this. In my work, this
wizard is very useful so I'd rather not have to work around it.
Any further ideas?
Cheers
Chrissqlsql
now trying to copy existing databased from other services but I can't get it
to work. I get the following error logged in the Event Viewer Application
Log:
"Log Name: Application
Source: Application Error
Date: 29/11/2007 16:16:56
Event ID: 1000
Task Category: (100)
Level: Error
Keywords: Classic
User: N/A
Computer: mycomputer
Description:
The description for Event ID 1000 from source Application Error cannot be
found. Either the component that raises this event is not installed on your
local computer or the installation is corrupted. You can install or repair
the component on the local computer.
If the event originated on another computer, the display information had to
be saved with the event.
The following information was included with the event:
DTExec.exe
2005.90.3042.0
45cd7539
kernel32.dll
6.0.6000.16386
4549d328
e053534f
00000000000233ac
The substitution string for insert index (%1) could not be found"
I cant find anything online that enlightens me - I know that Vista needs SP
installed to work, so I've installed it:
@.@.Version= Microsoft SQL Server 2005 - 9.00.3054.00 (X64)
Mar 23 2007 18:41:50
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition (64-bit) on Windows NT 6.0 (Build 6000: )
All the services are running under a domain user that has access to the
areas where the data is stored, both source and destination, so I'm hoping
it's not a permissions issue - if it is, I wouldnt know where to look.
I *could* copy a local database to the same server (renamed of course), so
it suggests that the server is largely OK - does this suggest it *is* a
permissions issue?
The domain user that the services are running under are not in the local
Administrators group, but they are in the
SQLServer2005MSSQLUser$MyComputer$MSSQLSERVER group - which I assume is the
group that was set up by the SQL Server Provisioning Tool for Vista.
This is a development machine so I frequently want to copy different
versions of different databases backwards and forwards.
Any suggestions? Any other Vista x64-ers out there?
Thanks in advance...
ChrisSQL Server uses Active Directory accounts and groups for its
permissions.
Active Directory accounts and groups are represented by GUIDs that are
unique to a particular Active Directory Domain which is run by a
Primary Domain Contoroller. If your new Vista machine is not part of
a network, or is on a different domain than the old one, then it
probably uses different GUIDs for the active directory accounts than
the source machine did. If you copied over the SQL Server database
using a backup, then you probably also copied all the old GUIDs for
the SQL Server accounts that point to the GUIDs on the old machine,
and not the ones on new machine.
This means that your SQL Server accounts are out of sync with active
directory. you may have to recreate your SQL Server accounts on the
new machine.
Permissions are assigned through SQL Server Management Studio in two
steps. First, you assign the active directory accounts that are
allowed to connect to a SQL Server instance. This is done by right
clicking the Logins folder under the Security folder of the SQL Server
instance the user is to connect to and selecting New Login.
Then, you assign what SQL Server instance users are allowed to connect
to a particular database within an instance. This is done by right
clicking the Security folder under the database you want to give
permission for and selecting New->user.
In both cases, an extensive permissions dialog will open. For the
Login folder, you only have to specify an active directory account.
For the Security folder, you have to click securables in the left
sidebar, add the entities you want to view (tables), and then set
select, reference, update, delete, and insert permissions. There are
more steps, but this should point you in the right direction.|||Andy, thanks for your reply...
"Andy" <anedza@.infotek-consulting.com> wrote in message
news:1ee305c9-338f-4a4f-9a42-198b42c597b5@.w40g2000hsb.googlegroups.com...
> If your new Vista machine is not part of
> a network, or is on a different domain than the old one,
>
My new machine is part of the same Domain and is recognised within Active
Directory.
> Permissions are assigned through SQL Server Management Studio in two
> steps. First, you assign the active directory accounts that are
> allowed to connect to a SQL Server instance. This is done by right
> clicking the Logins folder under the Security folder of the SQL Server
> instance the user is to connect to and selecting New Login.
Each human administrator is per of an SQL Admins group as are each of the
domain users that the different servers run under. On each server, the SQL
Admins group is added with a login and has sufficiend permissions (AFAIK).
> Then, you assign what SQL Server instance users are allowed to connect
> to a particular database within an instance. This is done by right
> clicking the Security folder under the database you want to give
> permission for and selecting New->user.
>
Done
> In both cases, an extensive permissions dialog will open. For the
> Login folder, you only have to specify an active directory account.
> For the Security folder, you have to click securables in the left
> sidebar, add the entities you want to view (tables), and then set
> select, reference, update, delete, and insert permissions. There are
> more steps, but this should point you in the right direction.
>
The login is set as a sysdamin so surely this shouldnt be necessary?
Somewhere in my tweaking, I've changed something. I *think* it's for the
better - I'm still getting errors but I'm getting further along.
I'm now getting Error 12550: Access to the path
'\\MyServer\MyShare\MyDB.mdf' is denied. The SQL Admins group has read/write
permissions to this area so I'm puzzled.
This is immediately followed by another Error 12550: Object reference not
set to an instance of an object. There are other errors further on, but I
think they are just as a consequence of these earlier errors.
I'm actually going to start copying backups because I need to crack on with
things, but I'm determined to get to the bottom of this. In my work, this
wizard is very useful so I'd rather not have to work around it.
Any further ideas?
Cheers
Chrissqlsql
Copy Database Wizard Default Destination Folder
We have installed Microsoft SQL Server 2005 to the deafult folder. However, we have another larger drive for our database files. We have changed the Server Properties > Database Settings to have the correct "Database default locations" that we want. However, when we use the Copy Database Wizard to bring over the many user databases on our existing server, the wizard always uses the original installation folder as the Destination Folders.
Is this a bug, or is there some way to change the defaults for these folders so we don't have to on every one?
Thanks
I have the same problem but by mistake I've found a way to modify the destination folder. On the grid with the destination folder click the one with the path. A label will appear over the grid and then you could edit the path. Cheers and hope that this will help you.Tuesday, March 20, 2012
copy database via tapefile no SQL 2005
Hello,
First do
"C:\Program
with
>
First do
>
RESTORE FILELISTONLY FROM TAPE = 'tapedevice'
>
this will give you the logical names of the files of the database. Then
do:
>
RESTORE DATABASE db FROM TAPE = 'tapedevice' WITH
MOVE 'datafile' TO
C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\KidDatabase.mdf',
Server\MSSQL.1\MSSQL\DATA\KidDatabase.ldf',
if you got a tape file how can you restore the contained database onto a
newly installed server? I choose Restore Database From Device then I choose
DB and select same DB in combobox "To Database" but error occured:
TITLE: Microsoft SQL Server Management Studio
Restore failed for Server '...'. (Microsoft.SqlServer.Smo)
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: Directory lookup for the file "C:\Program
Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\KidDatabase.mdf" failed with
the operating system error 3(error not found). (Microsoft.SqlServer.Smo)
what can I do to handle this problem?
regards
MarkMark (Scollop027@.gmx.net) writes:
Quote:
Originally Posted by
if you got a tape file how can you restore the contained database onto a
newly installed server? I choose Restore Database From Device then I
choose DB and select same DB in combobox "To Database" but error
occured:
>
TITLE: Microsoft SQL Server Management Studio
Restore failed for Server '...'. (Microsoft.SqlServer.Smo)
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: Directory lookup for the file "C:\Program
Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\KidDatabase.mdf" failed with
the operating system error 3(error not found). (Microsoft.SqlServer.Smo)
>
what can I do to handle this problem?
First do
RESTORE FILELISTONLY FROM TAPE = 'tapedevice'
this will give you the logical names of the files of the database. Then
do:
RESTORE DATABASE db FROM TAPE = 'tapedevice' WITH
MOVE 'datafile' TO
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\KidDatabase.mdf',
MOVE 'logfile' TO
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\KidDatabase.ldf',
REPLACE
Here I've used the path from your error message. Howver, the error message
indicates that this is a non-existing path, so you may have to examine
where there is place on the server to put the databases.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Hello Erland,
good tip, thank you very much !
I havent seen it :-/
regards Mark
"Erland Sommarskog" <esquel@.sommarskog.seschrieb im Newsbeitrag
news:Xns98203142E059Yazorman@.127.0.0.1...
Quote:
Originally Posted by
Mark (Scollop027@.gmx.net) writes:
Quote:
Originally Posted by
if you got a tape file how can you restore the contained database onto a
newly installed server? I choose Restore Database From Device then I
choose DB and select same DB in combobox "To Database" but error
occured:
TITLE: Microsoft SQL Server Management Studio
Restore failed for Server '...'. (Microsoft.SqlServer.Smo)
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: Directory lookup for the file
"C:\Program
Quote:
Originally Posted by
Quote:
Originally Posted by
Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\KidDatabase.mdf" failed
with
Quote:
Originally Posted by
Quote:
Originally Posted by
the operating system error 3(error not found). (Microsoft.SqlServer.Smo)
what can I do to handle this problem?
>
First do
>
RESTORE FILELISTONLY FROM TAPE = 'tapedevice'
>
this will give you the logical names of the files of the database. Then
do:
>
RESTORE DATABASE db FROM TAPE = 'tapedevice' WITH
MOVE 'datafile' TO
C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\KidDatabase.mdf',
Quote:
Originally Posted by
MOVE 'logfile' TO
C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\KidDatabase.ldf',
Quote:
Originally Posted by
REPLACE
>
Here I've used the path from your error message. Howver, the error message
indicates that this is a non-existing path, so you may have to examine
where there is place on the server to put the databases.
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
Monday, March 19, 2012
Copy Database problems SP2
Last night I installed SQL Server 2005 SP2. The install went fine and everything seemed to be fine. However a scheduled Database Copy job failed. I deleted the current job and recreated it using the "Copy Database" wizard. I used all the default values with the following exceptions: I used the "SQL Management Object Method" instead of the detach database and I use the "drop the database on destination". I tell it to run the job immediately and the job runs fine.
I then try to run the job again from SQL Agent -> jobs and it fails. I run it again and it runs fine. The pattern repeats, succeed -> fails -> succeed -> fails....
Here is the error message I receive in the history:
Message
Executed as user: EVAASSQLDEV\sqlagent. ...00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 9:30:06 AM Progress: 2007-03-30 09:30:07.41 Source: EVAASSQLDEV_evaassqldev_Transfer Objects Task Task just started the execution.: 0% complete End Progress Error: 2007-03-30 09:30:16.14 Code: 0x00000000 Source: EVAASSQLDEV_evaassqldev_Transfer Objects Task Description: Alter failed for Database 'PathwaysNewDev_new'. StackTrace: at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImpl() at Microsoft.SqlServer.Management.Smo.Database.Alter(TerminationClause terminationClause) at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.SwitchDatabaseAccess(Database database, DatabaseUserAccess desiredAccess) at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.CheckLocalandDestinationStatus(Database srcDatabase, DatabaseInfo dbDetail) at Mic... The package execution fa... The step failed.
How about privileges for that SQLAgent service account on both the servers?|||It is the same server. Just copying a development db to a testing db. One more thing though, when it fails it puts the destination DB in single user mode. I'm guessing it is trying to get exclusive control over the destination.
Sunday, March 11, 2012
copy database error (finding folder, login timeout)
Hello, just got SQL Server 2005 installed on a new production box and am
trying desperately to get data to it from an old SQL2000 production box -
unfortunately for me each time i try to use the copy database tools in order
to copy the database i get to the step where i am to "configure the package"
and the following popup appears:
While trying to find a folder on SQL an OLE DB error was encountered with
error code 0x80004005 (Login timeout expired).
I'm using the credentials of users who have sysAdmin priviledges.
Obviously this is leading to much hair pulling, screaming and near laptop
hurling. Someone please tell me what i'm doing wrong!?Matt
Why not just RESTORE the 'old' database (SQL Server 2000) to SQL Server
2005?
"Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
news:OdKJlO5uGHA.4512@.TK2MSFTNGP05.phx.gbl...
> Hello, just got SQL Server 2005 installed on a new production box and am
> trying desperately to get data to it from an old SQL2000 production box -
> unfortunately for me each time i try to use the copy database tools in
> order to copy the database i get to the step where i am to "configure the
> package" and the following popup appears:
> While trying to find a folder on SQL an OLE DB error was encountered with
> error code 0x80004005 (Login timeout expired).
> I'm using the credentials of users who have sysAdmin priviledges.
> Obviously this is leading to much hair pulling, screaming and near laptop
> hurling. Someone please tell me what i'm doing wrong!?
>|||I unfortunately have no upload access to the box to get a backup onto it to
be able to restore an old DB
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OB$rmW5uGHA.4612@.TK2MSFTNGP02.phx.gbl...
> Matt
> Why not just RESTORE the 'old' database (SQL Server 2000) to SQL Server
> 2005?
>
> "Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
> news:OdKJlO5uGHA.4512@.TK2MSFTNGP05.phx.gbl...
>|||Matt
I understood you use SQL Server200 as you wrote, did not you?
What tool dp you use to transfer the data? SSIS,DTS?
"Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
news:u4riyy5uGHA.3552@.TK2MSFTNGP03.phx.gbl...[vbcol=seagreen]
>I unfortunately have no upload access to the box to get a backup onto it to
>be able to restore an old DB
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OB$rmW5uGHA.4612@.TK2MSFTNGP02.phx.gbl...
>|||I think that this "I unfortunately have no upload access to the box" is the
clue to the situation.
SQL Server 'should' have permissions to the file system on the local server.
This error "While trying to find a folder on SQL an OLE DB error was
encountered with error code 0x80004005 (Login timeout expired)." makes it
seem like a file system permission issue.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
news:u4riyy5uGHA.3552@.TK2MSFTNGP03.phx.gbl...
>I unfortunately have no upload access to the box to get a backup onto it to
>be able to restore an old DB
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OB$rmW5uGHA.4612@.TK2MSFTNGP02.phx.gbl...
>
trying desperately to get data to it from an old SQL2000 production box -
unfortunately for me each time i try to use the copy database tools in order
to copy the database i get to the step where i am to "configure the package"
and the following popup appears:
While trying to find a folder on SQL an OLE DB error was encountered with
error code 0x80004005 (Login timeout expired).
I'm using the credentials of users who have sysAdmin priviledges.
Obviously this is leading to much hair pulling, screaming and near laptop
hurling. Someone please tell me what i'm doing wrong!?Matt
Why not just RESTORE the 'old' database (SQL Server 2000) to SQL Server
2005?
"Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
news:OdKJlO5uGHA.4512@.TK2MSFTNGP05.phx.gbl...
> Hello, just got SQL Server 2005 installed on a new production box and am
> trying desperately to get data to it from an old SQL2000 production box -
> unfortunately for me each time i try to use the copy database tools in
> order to copy the database i get to the step where i am to "configure the
> package" and the following popup appears:
> While trying to find a folder on SQL an OLE DB error was encountered with
> error code 0x80004005 (Login timeout expired).
> I'm using the credentials of users who have sysAdmin priviledges.
> Obviously this is leading to much hair pulling, screaming and near laptop
> hurling. Someone please tell me what i'm doing wrong!?
>|||I unfortunately have no upload access to the box to get a backup onto it to
be able to restore an old DB
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OB$rmW5uGHA.4612@.TK2MSFTNGP02.phx.gbl...
> Matt
> Why not just RESTORE the 'old' database (SQL Server 2000) to SQL Server
> 2005?
>
> "Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
> news:OdKJlO5uGHA.4512@.TK2MSFTNGP05.phx.gbl...
>|||Matt
I understood you use SQL Server200 as you wrote, did not you?
What tool dp you use to transfer the data? SSIS,DTS?
"Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
news:u4riyy5uGHA.3552@.TK2MSFTNGP03.phx.gbl...[vbcol=seagreen]
>I unfortunately have no upload access to the box to get a backup onto it to
>be able to restore an old DB
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OB$rmW5uGHA.4612@.TK2MSFTNGP02.phx.gbl...
>|||I think that this "I unfortunately have no upload access to the box" is the
clue to the situation.
SQL Server 'should' have permissions to the file system on the local server.
This error "While trying to find a folder on SQL an OLE DB error was
encountered with error code 0x80004005 (Login timeout expired)." makes it
seem like a file system permission issue.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
news:u4riyy5uGHA.3552@.TK2MSFTNGP03.phx.gbl...
>I unfortunately have no upload access to the box to get a backup onto it to
>be able to restore an old DB
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OB$rmW5uGHA.4612@.TK2MSFTNGP02.phx.gbl...
>
copy database error (finding folder, login timeout)
Hello, just got SQL Server 2005 installed on a new production box and am
trying desperately to get data to it from an old SQL2000 production box -
unfortunately for me each time i try to use the copy database tools in order
to copy the database i get to the step where i am to "configure the package"
and the following popup appears:
While trying to find a folder on SQL an OLE DB error was encountered with
error code 0x80004005 (Login timeout expired).
I'm using the credentials of users who have sysAdmin priviledges.
Obviously this is leading to much hair pulling, screaming and near laptop
hurling. Someone please tell me what i'm doing wrong!?Matt
Why not just RESTORE the 'old' database (SQL Server 2000) to SQL Server
2005?
"Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
news:OdKJlO5uGHA.4512@.TK2MSFTNGP05.phx.gbl...
> Hello, just got SQL Server 2005 installed on a new production box and am
> trying desperately to get data to it from an old SQL2000 production box -
> unfortunately for me each time i try to use the copy database tools in
> order to copy the database i get to the step where i am to "configure the
> package" and the following popup appears:
> While trying to find a folder on SQL an OLE DB error was encountered with
> error code 0x80004005 (Login timeout expired).
> I'm using the credentials of users who have sysAdmin priviledges.
> Obviously this is leading to much hair pulling, screaming and near laptop
> hurling. Someone please tell me what i'm doing wrong!?
>|||I unfortunately have no upload access to the box to get a backup onto it to
be able to restore an old DB :(
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OB$rmW5uGHA.4612@.TK2MSFTNGP02.phx.gbl...
> Matt
> Why not just RESTORE the 'old' database (SQL Server 2000) to SQL Server
> 2005?
>
> "Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
> news:OdKJlO5uGHA.4512@.TK2MSFTNGP05.phx.gbl...
>> Hello, just got SQL Server 2005 installed on a new production box and am
>> trying desperately to get data to it from an old SQL2000 production box -
>> unfortunately for me each time i try to use the copy database tools in
>> order to copy the database i get to the step where i am to "configure the
>> package" and the following popup appears:
>> While trying to find a folder on SQL an OLE DB error was encountered with
>> error code 0x80004005 (Login timeout expired).
>> I'm using the credentials of users who have sysAdmin priviledges.
>> Obviously this is leading to much hair pulling, screaming and near laptop
>> hurling. Someone please tell me what i'm doing wrong!?
>>
>|||Matt
>> trying desperately to get data to it from an old SQL2000 production
>> box - unfortunately for me each time i try to use the copy database
>> tools in order to copy the database i get to the step where i am to
>> "configure the package" and the following popup appears:
I understood you use SQL Server200 as you wrote, did not you?
What tool dp you use to transfer the data? SSIS,DTS?
"Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
news:u4riyy5uGHA.3552@.TK2MSFTNGP03.phx.gbl...
>I unfortunately have no upload access to the box to get a backup onto it to
>be able to restore an old DB :(
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OB$rmW5uGHA.4612@.TK2MSFTNGP02.phx.gbl...
>> Matt
>> Why not just RESTORE the 'old' database (SQL Server 2000) to SQL Server
>> 2005?
>>
>> "Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
>> news:OdKJlO5uGHA.4512@.TK2MSFTNGP05.phx.gbl...
>> Hello, just got SQL Server 2005 installed on a new production box and am
>> trying desperately to get data to it from an old SQL2000 production
>> box - unfortunately for me each time i try to use the copy database
>> tools in order to copy the database i get to the step where i am to
>> "configure the package" and the following popup appears:
>> While trying to find a folder on SQL an OLE DB error was encountered
>> with error code 0x80004005 (Login timeout expired).
>> I'm using the credentials of users who have sysAdmin priviledges.
>> Obviously this is leading to much hair pulling, screaming and near
>> laptop hurling. Someone please tell me what i'm doing wrong!?
>>
>>
>|||I think that this "I unfortunately have no upload access to the box" is the
clue to the situation.
SQL Server 'should' have permissions to the file system on the local server.
This error "While trying to find a folder on SQL an OLE DB error was
encountered with error code 0x80004005 (Login timeout expired)." makes it
seem like a file system permission issue.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
news:u4riyy5uGHA.3552@.TK2MSFTNGP03.phx.gbl...
>I unfortunately have no upload access to the box to get a backup onto it to
>be able to restore an old DB :(
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OB$rmW5uGHA.4612@.TK2MSFTNGP02.phx.gbl...
>> Matt
>> Why not just RESTORE the 'old' database (SQL Server 2000) to SQL Server
>> 2005?
>>
>> "Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
>> news:OdKJlO5uGHA.4512@.TK2MSFTNGP05.phx.gbl...
>> Hello, just got SQL Server 2005 installed on a new production box and am
>> trying desperately to get data to it from an old SQL2000 production
>> box - unfortunately for me each time i try to use the copy database
>> tools in order to copy the database i get to the step where i am to
>> "configure the package" and the following popup appears:
>> While trying to find a folder on SQL an OLE DB error was encountered
>> with error code 0x80004005 (Login timeout expired).
>> I'm using the credentials of users who have sysAdmin priviledges.
>> Obviously this is leading to much hair pulling, screaming and near
>> laptop hurling. Someone please tell me what i'm doing wrong!?
>>
>>
>
trying desperately to get data to it from an old SQL2000 production box -
unfortunately for me each time i try to use the copy database tools in order
to copy the database i get to the step where i am to "configure the package"
and the following popup appears:
While trying to find a folder on SQL an OLE DB error was encountered with
error code 0x80004005 (Login timeout expired).
I'm using the credentials of users who have sysAdmin priviledges.
Obviously this is leading to much hair pulling, screaming and near laptop
hurling. Someone please tell me what i'm doing wrong!?Matt
Why not just RESTORE the 'old' database (SQL Server 2000) to SQL Server
2005?
"Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
news:OdKJlO5uGHA.4512@.TK2MSFTNGP05.phx.gbl...
> Hello, just got SQL Server 2005 installed on a new production box and am
> trying desperately to get data to it from an old SQL2000 production box -
> unfortunately for me each time i try to use the copy database tools in
> order to copy the database i get to the step where i am to "configure the
> package" and the following popup appears:
> While trying to find a folder on SQL an OLE DB error was encountered with
> error code 0x80004005 (Login timeout expired).
> I'm using the credentials of users who have sysAdmin priviledges.
> Obviously this is leading to much hair pulling, screaming and near laptop
> hurling. Someone please tell me what i'm doing wrong!?
>|||I unfortunately have no upload access to the box to get a backup onto it to
be able to restore an old DB :(
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OB$rmW5uGHA.4612@.TK2MSFTNGP02.phx.gbl...
> Matt
> Why not just RESTORE the 'old' database (SQL Server 2000) to SQL Server
> 2005?
>
> "Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
> news:OdKJlO5uGHA.4512@.TK2MSFTNGP05.phx.gbl...
>> Hello, just got SQL Server 2005 installed on a new production box and am
>> trying desperately to get data to it from an old SQL2000 production box -
>> unfortunately for me each time i try to use the copy database tools in
>> order to copy the database i get to the step where i am to "configure the
>> package" and the following popup appears:
>> While trying to find a folder on SQL an OLE DB error was encountered with
>> error code 0x80004005 (Login timeout expired).
>> I'm using the credentials of users who have sysAdmin priviledges.
>> Obviously this is leading to much hair pulling, screaming and near laptop
>> hurling. Someone please tell me what i'm doing wrong!?
>>
>|||Matt
>> trying desperately to get data to it from an old SQL2000 production
>> box - unfortunately for me each time i try to use the copy database
>> tools in order to copy the database i get to the step where i am to
>> "configure the package" and the following popup appears:
I understood you use SQL Server200 as you wrote, did not you?
What tool dp you use to transfer the data? SSIS,DTS?
"Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
news:u4riyy5uGHA.3552@.TK2MSFTNGP03.phx.gbl...
>I unfortunately have no upload access to the box to get a backup onto it to
>be able to restore an old DB :(
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OB$rmW5uGHA.4612@.TK2MSFTNGP02.phx.gbl...
>> Matt
>> Why not just RESTORE the 'old' database (SQL Server 2000) to SQL Server
>> 2005?
>>
>> "Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
>> news:OdKJlO5uGHA.4512@.TK2MSFTNGP05.phx.gbl...
>> Hello, just got SQL Server 2005 installed on a new production box and am
>> trying desperately to get data to it from an old SQL2000 production
>> box - unfortunately for me each time i try to use the copy database
>> tools in order to copy the database i get to the step where i am to
>> "configure the package" and the following popup appears:
>> While trying to find a folder on SQL an OLE DB error was encountered
>> with error code 0x80004005 (Login timeout expired).
>> I'm using the credentials of users who have sysAdmin priviledges.
>> Obviously this is leading to much hair pulling, screaming and near
>> laptop hurling. Someone please tell me what i'm doing wrong!?
>>
>>
>|||I think that this "I unfortunately have no upload access to the box" is the
clue to the situation.
SQL Server 'should' have permissions to the file system on the local server.
This error "While trying to find a folder on SQL an OLE DB error was
encountered with error code 0x80004005 (Login timeout expired)." makes it
seem like a file system permission issue.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
news:u4riyy5uGHA.3552@.TK2MSFTNGP03.phx.gbl...
>I unfortunately have no upload access to the box to get a backup onto it to
>be able to restore an old DB :(
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OB$rmW5uGHA.4612@.TK2MSFTNGP02.phx.gbl...
>> Matt
>> Why not just RESTORE the 'old' database (SQL Server 2000) to SQL Server
>> 2005?
>>
>> "Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
>> news:OdKJlO5uGHA.4512@.TK2MSFTNGP05.phx.gbl...
>> Hello, just got SQL Server 2005 installed on a new production box and am
>> trying desperately to get data to it from an old SQL2000 production
>> box - unfortunately for me each time i try to use the copy database
>> tools in order to copy the database i get to the step where i am to
>> "configure the package" and the following popup appears:
>> While trying to find a folder on SQL an OLE DB error was encountered
>> with error code 0x80004005 (Login timeout expired).
>> I'm using the credentials of users who have sysAdmin priviledges.
>> Obviously this is leading to much hair pulling, screaming and near
>> laptop hurling. Someone please tell me what i'm doing wrong!?
>>
>>
>
Sunday, February 19, 2012
Converting to MSDE - stuck already!
I just installed MSDE on my desktop and for my first project took a copy of
one of my Access 2000 databases I have used for years and upsized it. There
were many errors, especially in the queries/views. I expected some errors.
This personal database completely resides on my PC, tables and all. When I
upsized it, it copied the tables over empty - no data. So I copied and
pasted data into the Switchboard table and others.
Then I tried to open the Switchboard form that was created automatically
when I first created the database.
This was the first programming error I encountered.
Private Sub FillOptions()
' Fill in the options for this switchboard page.
' The number of buttons on the form.
Const conNumButtons = 8
Dim dbs As Database
Dim rst As Recordset
Dim strSQL As String
Dim intOption As Integer
' Set the focus to the first button on the form,
' and then hide all of the buttons on the form
' but the first. You can't hide the field with the focus.
Me![Option1].SetFocus
For intOption = 2 To conNumButtons
Me("Option" & intOption).Visible = False
Me("OptionLabel" & intOption).Visible = False
Next intOption
' Open the table of Switchboard Items, and find
' the first item for this Switchboard Page.
Set dbs = CurrentDb()
strSQL = "SELECT * FROM [Switchboard Items]"
strSQL = strSQL & " WHERE [ItemNumber] > 0 AND [SwitchboardID]=" &
Me![SwitchboardID]
strSQL = strSQL & " ORDER BY [ItemNumber];"
Set rst = dbs.OpenRecordset(strSQL) 'XXXXX error message occurs here
XXXXX
' If there are no options for this Switchboard Page,
' display a message. Otherwise, fill the page with the items.
If (rst.EOF) Then
Me![OptionLabel1].Caption = "There are no items for this switchboard
page"
Else
While (Not (rst.EOF))
Me("Option" & rst![ItemNumber]).Visible = True
Me("OptionLabel" & rst![ItemNumber]).Visible = True
Me("OptionLabel" & rst![ItemNumber]).Caption = rst![ItemText]
rst.MoveNext
Wend
End If
' Close the recordset and the database.
rst.Close
dbs.Close
End Sub
I get a run time error 91, object variable or With block variable not set.
Help says for error 91: First you must declare the object variable. Then you
must assign a valid reference to the object variable using the Set
statement.
I have declared and set both the database and recordset.
Since I am totally new to MSDE, can anyone guide me to where I can find out
more about this and other errors I am sure to encounter?
Thanks,
Mich
I suspect that your problem is occurring with the statement
Set dbs = CurrentDb()
How are you connecting from Access to the MSDE tables?
Chuck Heinzelman - MCSD, MCDBA
(Please respond only to the newsgroups.)
I support the Professional Association for SQL Server and its community of
SQL Server professionals.
www.sqlpass.org
"M Skabialka" <mskabialka@.NOSPAMdrc.com> wrote in message
news:uGv1gzqGFHA.3628@.TK2MSFTNGP15.phx.gbl...
> I just installed MSDE on my desktop and for my first project took a copy
of
> one of my Access 2000 databases I have used for years and upsized it.
There
> were many errors, especially in the queries/views. I expected some
errors.
> This personal database completely resides on my PC, tables and all. When
I
> upsized it, it copied the tables over empty - no data. So I copied and
> pasted data into the Switchboard table and others.
> Then I tried to open the Switchboard form that was created automatically
> when I first created the database.
> This was the first programming error I encountered.
> Private Sub FillOptions()
> ' Fill in the options for this switchboard page.
> ' The number of buttons on the form.
> Const conNumButtons = 8
> Dim dbs As Database
> Dim rst As Recordset
> Dim strSQL As String
> Dim intOption As Integer
> ' Set the focus to the first button on the form,
> ' and then hide all of the buttons on the form
> ' but the first. You can't hide the field with the focus.
> Me![Option1].SetFocus
> For intOption = 2 To conNumButtons
> Me("Option" & intOption).Visible = False
> Me("OptionLabel" & intOption).Visible = False
> Next intOption
> ' Open the table of Switchboard Items, and find
> ' the first item for this Switchboard Page.
> Set dbs = CurrentDb()
> strSQL = "SELECT * FROM [Switchboard Items]"
> strSQL = strSQL & " WHERE [ItemNumber] > 0 AND [SwitchboardID]=" &
> Me![SwitchboardID]
> strSQL = strSQL & " ORDER BY [ItemNumber];"
> Set rst = dbs.OpenRecordset(strSQL) 'XXXXX error message occurs
here
> XXXXX
> ' If there are no options for this Switchboard Page,
> ' display a message. Otherwise, fill the page with the items.
> If (rst.EOF) Then
> Me![OptionLabel1].Caption = "There are no items for this
switchboard
> page"
> Else
> While (Not (rst.EOF))
> Me("Option" & rst![ItemNumber]).Visible = True
> Me("OptionLabel" & rst![ItemNumber]).Visible = True
> Me("OptionLabel" & rst![ItemNumber]).Caption = rst![ItemText]
> rst.MoveNext
> Wend
> End If
> ' Close the recordset and the database.
> rst.Close
> dbs.Close
> End Sub
> I get a run time error 91, object variable or With block variable not set.
> Help says for error 91: First you must declare the object variable. Then
you
> must assign a valid reference to the object variable using the Set
> statement.
> I have declared and set both the database and recordset.
> Since I am totally new to MSDE, can anyone guide me to where I can find
out
> more about this and other errors I am sure to encounter?
> Thanks,
> Mich
>
one of my Access 2000 databases I have used for years and upsized it. There
were many errors, especially in the queries/views. I expected some errors.
This personal database completely resides on my PC, tables and all. When I
upsized it, it copied the tables over empty - no data. So I copied and
pasted data into the Switchboard table and others.
Then I tried to open the Switchboard form that was created automatically
when I first created the database.
This was the first programming error I encountered.
Private Sub FillOptions()
' Fill in the options for this switchboard page.
' The number of buttons on the form.
Const conNumButtons = 8
Dim dbs As Database
Dim rst As Recordset
Dim strSQL As String
Dim intOption As Integer
' Set the focus to the first button on the form,
' and then hide all of the buttons on the form
' but the first. You can't hide the field with the focus.
Me![Option1].SetFocus
For intOption = 2 To conNumButtons
Me("Option" & intOption).Visible = False
Me("OptionLabel" & intOption).Visible = False
Next intOption
' Open the table of Switchboard Items, and find
' the first item for this Switchboard Page.
Set dbs = CurrentDb()
strSQL = "SELECT * FROM [Switchboard Items]"
strSQL = strSQL & " WHERE [ItemNumber] > 0 AND [SwitchboardID]=" &
Me![SwitchboardID]
strSQL = strSQL & " ORDER BY [ItemNumber];"
Set rst = dbs.OpenRecordset(strSQL) 'XXXXX error message occurs here
XXXXX
' If there are no options for this Switchboard Page,
' display a message. Otherwise, fill the page with the items.
If (rst.EOF) Then
Me![OptionLabel1].Caption = "There are no items for this switchboard
page"
Else
While (Not (rst.EOF))
Me("Option" & rst![ItemNumber]).Visible = True
Me("OptionLabel" & rst![ItemNumber]).Visible = True
Me("OptionLabel" & rst![ItemNumber]).Caption = rst![ItemText]
rst.MoveNext
Wend
End If
' Close the recordset and the database.
rst.Close
dbs.Close
End Sub
I get a run time error 91, object variable or With block variable not set.
Help says for error 91: First you must declare the object variable. Then you
must assign a valid reference to the object variable using the Set
statement.
I have declared and set both the database and recordset.
Since I am totally new to MSDE, can anyone guide me to where I can find out
more about this and other errors I am sure to encounter?
Thanks,
Mich
I suspect that your problem is occurring with the statement
Set dbs = CurrentDb()
How are you connecting from Access to the MSDE tables?
Chuck Heinzelman - MCSD, MCDBA
(Please respond only to the newsgroups.)
I support the Professional Association for SQL Server and its community of
SQL Server professionals.
www.sqlpass.org
"M Skabialka" <mskabialka@.NOSPAMdrc.com> wrote in message
news:uGv1gzqGFHA.3628@.TK2MSFTNGP15.phx.gbl...
> I just installed MSDE on my desktop and for my first project took a copy
of
> one of my Access 2000 databases I have used for years and upsized it.
There
> were many errors, especially in the queries/views. I expected some
errors.
> This personal database completely resides on my PC, tables and all. When
I
> upsized it, it copied the tables over empty - no data. So I copied and
> pasted data into the Switchboard table and others.
> Then I tried to open the Switchboard form that was created automatically
> when I first created the database.
> This was the first programming error I encountered.
> Private Sub FillOptions()
> ' Fill in the options for this switchboard page.
> ' The number of buttons on the form.
> Const conNumButtons = 8
> Dim dbs As Database
> Dim rst As Recordset
> Dim strSQL As String
> Dim intOption As Integer
> ' Set the focus to the first button on the form,
> ' and then hide all of the buttons on the form
> ' but the first. You can't hide the field with the focus.
> Me![Option1].SetFocus
> For intOption = 2 To conNumButtons
> Me("Option" & intOption).Visible = False
> Me("OptionLabel" & intOption).Visible = False
> Next intOption
> ' Open the table of Switchboard Items, and find
> ' the first item for this Switchboard Page.
> Set dbs = CurrentDb()
> strSQL = "SELECT * FROM [Switchboard Items]"
> strSQL = strSQL & " WHERE [ItemNumber] > 0 AND [SwitchboardID]=" &
> Me![SwitchboardID]
> strSQL = strSQL & " ORDER BY [ItemNumber];"
> Set rst = dbs.OpenRecordset(strSQL) 'XXXXX error message occurs
here
> XXXXX
> ' If there are no options for this Switchboard Page,
> ' display a message. Otherwise, fill the page with the items.
> If (rst.EOF) Then
> Me![OptionLabel1].Caption = "There are no items for this
switchboard
> page"
> Else
> While (Not (rst.EOF))
> Me("Option" & rst![ItemNumber]).Visible = True
> Me("OptionLabel" & rst![ItemNumber]).Visible = True
> Me("OptionLabel" & rst![ItemNumber]).Caption = rst![ItemText]
> rst.MoveNext
> Wend
> End If
> ' Close the recordset and the database.
> rst.Close
> dbs.Close
> End Sub
> I get a run time error 91, object variable or With block variable not set.
> Help says for error 91: First you must declare the object variable. Then
you
> must assign a valid reference to the object variable using the Set
> statement.
> I have declared and set both the database and recordset.
> Since I am totally new to MSDE, can anyone guide me to where I can find
out
> more about this and other errors I am sure to encounter?
> Thanks,
> Mich
>
Friday, February 10, 2012
Converting MSDE databse to mixed mode
I installed MSDE on windows server 2003 a few days ago but did not make the installation mixed mode because the documentation insisted that Windows Authentication was better. Now I am stuck with a database that I cannot connect to through anything. I ha
ve tried figuring out how to switch to mixed mode but documentation on MSDE is nearly nonexistent. I also tried to figure out how to uninstall a database but there is no mention of this anywhere.
Is there a way to switch to mixed mode, and if there is, what exactly am I supposed to do with the sa password I gave, i still haven't figured out what it is used for, and how would it be different from the sql login information.
I am using the database for DotNetNuke and have read that sql is a better choice than access so i'd like to give this another shot. Also how does MSDE compare to the standard SQL, am I better off running access? Thanks.
Hi,
Go to registry key HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode
..
if the value is 1 then it is NT authentication , changing the value to 2
would get the server into mixed mode.
You need to stop and start the MSSQL server services after the registry
change.
See the detailed KB artticle which explains the diffrent methods to change
the authentication during installation and after.
http://support.microsoft.com/default...b;en-us;285097
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:D14C0B26-13BC-4479-970E-46DF471C23A6@.microsoft.com...
> I installed MSDE on windows server 2003 a few days ago but did not make
the installation mixed mode because the documentation insisted that Windows
Authentication was better. Now I am stuck with a database that I cannot
connect to through anything. I have tried figuring out how to switch to
mixed mode but documentation on MSDE is nearly nonexistent. I also tried to
figure out how to uninstall a database but there is no mention of this
anywhere.
> Is there a way to switch to mixed mode, and if there is, what exactly am I
supposed to do with the sa password I gave, i still haven't figured out what
it is used for, and how would it be different from the sql login
information.
> I am using the database for DotNetNuke and have read that sql is a better
choice than access so i'd like to give this another shot. Also how does
MSDE compare to the standard SQL, am I better off running access? Thanks.
|||how would i set the sql login id and password, and what would i use my sa password i came up with for Windows Authentication?
"Hari Prasad" wrote:
> Hi,
> Go to registry key HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode
> ..
> if the value is 1 then it is NT authentication , changing the value to 2
> would get the server into mixed mode.
> You need to stop and start the MSSQL server services after the registry
> change.
> See the detailed KB artticle which explains the diffrent methods to change
> the authentication during installation and after.
> http://support.microsoft.com/default...b;en-us;285097
> Thanks
> Hari
> MCDBA
> "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> news:D14C0B26-13BC-4479-970E-46DF471C23A6@.microsoft.com...
> the installation mixed mode because the documentation insisted that Windows
> Authentication was better. Now I am stuck with a database that I cannot
> connect to through anything. I have tried figuring out how to switch to
> mixed mode but documentation on MSDE is nearly nonexistent. I also tried to
> figure out how to uninstall a database but there is no mention of this
> anywhere.
> supposed to do with the sa password I gave, i still haven't figured out what
> it is used for, and how would it be different from the sql login
> information.
> choice than access so i'd like to give this another shot. Also how does
> MSDE compare to the standard SQL, am I better off running access? Thanks.
>
>
|||Hi,
Try the below from command prompt with password as blank.
osql -Usa -P -Sservername
If it is not allowng login with trusteed connection using:
OSQL -E -Sservername (enter)
1>sp_password null,'newpassword','sa'
2>go
After that try connecting using the new password for sa.
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:EC472035-7FC2-4313-8E35-626B8110E6DB@.microsoft.com...
> how would i set the sql login id and password, and what would i use my sa
password i came up with for Windows Authentication?[vbcol=seagreen]
> "Hari Prasad" wrote:
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode[vbcol=seagreen]
2[vbcol=seagreen]
change[vbcol=seagreen]
make[vbcol=seagreen]
Windows[vbcol=seagreen]
tried to[vbcol=seagreen]
am I[vbcol=seagreen]
what[vbcol=seagreen]
better[vbcol=seagreen]
Thanks.[vbcol=seagreen]
|||I can no longer start the sql database. I get two error messages when trying:
First: "The service cannot be started, either because it is disabled or because it has no enabled devices associated with it."
After clicking ok I get:
"An error 1058 - (The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.) occured while performing this service operation on the MSSQLServer service."
The key I changed was:
HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/MSSQLServer/MSSQLServer/LoginMode from 2 to 0.
"Hari Prasad" wrote:
> Hi,
> Try the below from command prompt with password as blank.
> osql -Usa -P -Sservername
> If it is not allowng login with trusteed connection using:
> OSQL -E -Sservername (enter)
> 1>sp_password null,'newpassword','sa'
> 2>go
> After that try connecting using the new password for sa.
>
> Thanks
> Hari
> MCDBA
> "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> news:EC472035-7FC2-4313-8E35-626B8110E6DB@.microsoft.com...
> password i came up with for Windows Authentication?
> HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode
> 2
> change
> make
> Windows
> tried to
> am I
> what
> better
> Thanks.
>
>
|||Hi,
The value 2 itself is Mixed mode. Can you change back the value to old and
restart the MSSQL server service.
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:42BC7C0F-D364-43C8-A512-86A537132000@.microsoft.com...
> I can no longer start the sql database. I get two error messages when
trying:
> First: "The service cannot be started, either because it is disabled or
because it has no enabled devices associated with it."
> After clicking ok I get:
> "An error 1058 - (The service cannot be started, either because it is
disabled or because it has no enabled devices associated with it.) occured
while performing this service operation on the MSSQLServer service."
> The key I changed was:
> HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/MSSQLServer/MSSQLServer/LoginMode
from 2 to 0.[vbcol=seagreen]
> "Hari Prasad" wrote:
sa[vbcol=seagreen]
to[vbcol=seagreen]
registry[vbcol=seagreen]
cannot[vbcol=seagreen]
switch to[vbcol=seagreen]
this[vbcol=seagreen]
exactly[vbcol=seagreen]
out[vbcol=seagreen]
does[vbcol=seagreen]
|||ok thank you, i got it to work and changed the sa password. Was this necessary if I had installed it with SAPWD="password." Should I create a new user account for use with my dotnetnuke portal or should i just use the sa account? Also why do I keep rea
ding everywhere that Windows Authentication is better yet it doesn't explain how to have anonymous users from the net use it, was Windows Authentication designed only for intranet. Thanks again. on a side note what's the purpose of the null in the comma
nd you posted last? Is there a site that lists the osql commands in detail?
"Hari Prasad" wrote:
> Hi,
>
> The value 2 itself is Mixed mode. Can you change back the value to old and
> restart the MSSQL server service.
> Thanks
> Hari
> MCDBA
> "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> news:42BC7C0F-D364-43C8-A512-86A537132000@.microsoft.com...
> trying:
> because it has no enabled devices associated with it."
> disabled or because it has no enabled devices associated with it.) occured
> while performing this service operation on the MSSQLServer service."
> from 2 to 0.
> sa
> to
> registry
> cannot
> switch to
> this
> exactly
> out
> does
>
>
ve tried figuring out how to switch to mixed mode but documentation on MSDE is nearly nonexistent. I also tried to figure out how to uninstall a database but there is no mention of this anywhere.
Is there a way to switch to mixed mode, and if there is, what exactly am I supposed to do with the sa password I gave, i still haven't figured out what it is used for, and how would it be different from the sql login information.
I am using the database for DotNetNuke and have read that sql is a better choice than access so i'd like to give this another shot. Also how does MSDE compare to the standard SQL, am I better off running access? Thanks.
Hi,
Go to registry key HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode
..
if the value is 1 then it is NT authentication , changing the value to 2
would get the server into mixed mode.
You need to stop and start the MSSQL server services after the registry
change.
See the detailed KB artticle which explains the diffrent methods to change
the authentication during installation and after.
http://support.microsoft.com/default...b;en-us;285097
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:D14C0B26-13BC-4479-970E-46DF471C23A6@.microsoft.com...
> I installed MSDE on windows server 2003 a few days ago but did not make
the installation mixed mode because the documentation insisted that Windows
Authentication was better. Now I am stuck with a database that I cannot
connect to through anything. I have tried figuring out how to switch to
mixed mode but documentation on MSDE is nearly nonexistent. I also tried to
figure out how to uninstall a database but there is no mention of this
anywhere.
> Is there a way to switch to mixed mode, and if there is, what exactly am I
supposed to do with the sa password I gave, i still haven't figured out what
it is used for, and how would it be different from the sql login
information.
> I am using the database for DotNetNuke and have read that sql is a better
choice than access so i'd like to give this another shot. Also how does
MSDE compare to the standard SQL, am I better off running access? Thanks.
|||how would i set the sql login id and password, and what would i use my sa password i came up with for Windows Authentication?
"Hari Prasad" wrote:
> Hi,
> Go to registry key HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode
> ..
> if the value is 1 then it is NT authentication , changing the value to 2
> would get the server into mixed mode.
> You need to stop and start the MSSQL server services after the registry
> change.
> See the detailed KB artticle which explains the diffrent methods to change
> the authentication during installation and after.
> http://support.microsoft.com/default...b;en-us;285097
> Thanks
> Hari
> MCDBA
> "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> news:D14C0B26-13BC-4479-970E-46DF471C23A6@.microsoft.com...
> the installation mixed mode because the documentation insisted that Windows
> Authentication was better. Now I am stuck with a database that I cannot
> connect to through anything. I have tried figuring out how to switch to
> mixed mode but documentation on MSDE is nearly nonexistent. I also tried to
> figure out how to uninstall a database but there is no mention of this
> anywhere.
> supposed to do with the sa password I gave, i still haven't figured out what
> it is used for, and how would it be different from the sql login
> information.
> choice than access so i'd like to give this another shot. Also how does
> MSDE compare to the standard SQL, am I better off running access? Thanks.
>
>
|||Hi,
Try the below from command prompt with password as blank.
osql -Usa -P -Sservername
If it is not allowng login with trusteed connection using:
OSQL -E -Sservername (enter)
1>sp_password null,'newpassword','sa'
2>go
After that try connecting using the new password for sa.
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:EC472035-7FC2-4313-8E35-626B8110E6DB@.microsoft.com...
> how would i set the sql login id and password, and what would i use my sa
password i came up with for Windows Authentication?[vbcol=seagreen]
> "Hari Prasad" wrote:
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode[vbcol=seagreen]
2[vbcol=seagreen]
change[vbcol=seagreen]
make[vbcol=seagreen]
Windows[vbcol=seagreen]
tried to[vbcol=seagreen]
am I[vbcol=seagreen]
what[vbcol=seagreen]
better[vbcol=seagreen]
Thanks.[vbcol=seagreen]
|||I can no longer start the sql database. I get two error messages when trying:
First: "The service cannot be started, either because it is disabled or because it has no enabled devices associated with it."
After clicking ok I get:
"An error 1058 - (The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.) occured while performing this service operation on the MSSQLServer service."
The key I changed was:
HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/MSSQLServer/MSSQLServer/LoginMode from 2 to 0.
"Hari Prasad" wrote:
> Hi,
> Try the below from command prompt with password as blank.
> osql -Usa -P -Sservername
> If it is not allowng login with trusteed connection using:
> OSQL -E -Sservername (enter)
> 1>sp_password null,'newpassword','sa'
> 2>go
> After that try connecting using the new password for sa.
>
> Thanks
> Hari
> MCDBA
> "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> news:EC472035-7FC2-4313-8E35-626B8110E6DB@.microsoft.com...
> password i came up with for Windows Authentication?
> HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode
> 2
> change
> make
> Windows
> tried to
> am I
> what
> better
> Thanks.
>
>
|||Hi,
The value 2 itself is Mixed mode. Can you change back the value to old and
restart the MSSQL server service.
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:42BC7C0F-D364-43C8-A512-86A537132000@.microsoft.com...
> I can no longer start the sql database. I get two error messages when
trying:
> First: "The service cannot be started, either because it is disabled or
because it has no enabled devices associated with it."
> After clicking ok I get:
> "An error 1058 - (The service cannot be started, either because it is
disabled or because it has no enabled devices associated with it.) occured
while performing this service operation on the MSSQLServer service."
> The key I changed was:
> HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/MSSQLServer/MSSQLServer/LoginMode
from 2 to 0.[vbcol=seagreen]
> "Hari Prasad" wrote:
sa[vbcol=seagreen]
to[vbcol=seagreen]
registry[vbcol=seagreen]
cannot[vbcol=seagreen]
switch to[vbcol=seagreen]
this[vbcol=seagreen]
exactly[vbcol=seagreen]
out[vbcol=seagreen]
does[vbcol=seagreen]
|||ok thank you, i got it to work and changed the sa password. Was this necessary if I had installed it with SAPWD="password." Should I create a new user account for use with my dotnetnuke portal or should i just use the sa account? Also why do I keep rea
ding everywhere that Windows Authentication is better yet it doesn't explain how to have anonymous users from the net use it, was Windows Authentication designed only for intranet. Thanks again. on a side note what's the purpose of the null in the comma
nd you posted last? Is there a site that lists the osql commands in detail?
"Hari Prasad" wrote:
> Hi,
>
> The value 2 itself is Mixed mode. Can you change back the value to old and
> restart the MSSQL server service.
> Thanks
> Hari
> MCDBA
> "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> news:42BC7C0F-D364-43C8-A512-86A537132000@.microsoft.com...
> trying:
> because it has no enabled devices associated with it."
> disabled or because it has no enabled devices associated with it.) occured
> while performing this service operation on the MSSQLServer service."
> from 2 to 0.
> sa
> to
> registry
> cannot
> switch to
> this
> exactly
> out
> does
>
>
Converting MSDE databse to mixed mode
I installed MSDE on windows server 2003 a few days ago but did not make the installation mixed mode because the documentation insisted that Windows Authentication was better. Now I am stuck with a database that I cannot connect to through anything. I have tried figuring out how to switch to mixed mode but documentation on MSDE is nearly nonexistent. I also tried to figure out how to uninstall a database but there is no mention of this anywhere.
Is there a way to switch to mixed mode, and if there is, what exactly am I supposed to do with the sa password I gave, i still haven't figured out what it is used for, and how would it be different from the sql login information.
I am using the database for DotNetNuke and have read that sql is a better choice than access so i'd like to give this another shot. Also how does MSDE compare to the standard SQL, am I better off running access? Thanks.Hi,
Go to registry key HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
.
if the value is 1 then it is NT authentication , changing the value to 2
would get the server into mixed mode.
You need to stop and start the MSSQL server services after the registry
change.
See the detailed KB artticle which explains the diffrent methods to change
the authentication during installation and after.
http://support.microsoft.com/default.aspx?scid=kb;en-us;285097
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:D14C0B26-13BC-4479-970E-46DF471C23A6@.microsoft.com...
> I installed MSDE on windows server 2003 a few days ago but did not make
the installation mixed mode because the documentation insisted that Windows
Authentication was better. Now I am stuck with a database that I cannot
connect to through anything. I have tried figuring out how to switch to
mixed mode but documentation on MSDE is nearly nonexistent. I also tried to
figure out how to uninstall a database but there is no mention of this
anywhere.
> Is there a way to switch to mixed mode, and if there is, what exactly am I
supposed to do with the sa password I gave, i still haven't figured out what
it is used for, and how would it be different from the sql login
information.
> I am using the database for DotNetNuke and have read that sql is a better
choice than access so i'd like to give this another shot. Also how does
MSDE compare to the standard SQL, am I better off running access? Thanks.|||how would i set the sql login id and password, and what would i use my sa password i came up with for Windows Authentication?
"Hari Prasad" wrote:
> Hi,
> Go to registry key HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
> ..
> if the value is 1 then it is NT authentication , changing the value to 2
> would get the server into mixed mode.
> You need to stop and start the MSSQL server services after the registry
> change.
> See the detailed KB artticle which explains the diffrent methods to change
> the authentication during installation and after.
> http://support.microsoft.com/default.aspx?scid=kb;en-us;285097
> Thanks
> Hari
> MCDBA
> "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> news:D14C0B26-13BC-4479-970E-46DF471C23A6@.microsoft.com...
> > I installed MSDE on windows server 2003 a few days ago but did not make
> the installation mixed mode because the documentation insisted that Windows
> Authentication was better. Now I am stuck with a database that I cannot
> connect to through anything. I have tried figuring out how to switch to
> mixed mode but documentation on MSDE is nearly nonexistent. I also tried to
> figure out how to uninstall a database but there is no mention of this
> anywhere.
> >
> > Is there a way to switch to mixed mode, and if there is, what exactly am I
> supposed to do with the sa password I gave, i still haven't figured out what
> it is used for, and how would it be different from the sql login
> information.
> >
> > I am using the database for DotNetNuke and have read that sql is a better
> choice than access so i'd like to give this another shot. Also how does
> MSDE compare to the standard SQL, am I better off running access? Thanks.
>
>|||Hi,
Try the below from command prompt with password as blank.
osql -Usa -P -Sservername
If it is not allowng login with trusteed connection using:
OSQL -E -Sservername (enter)
1>sp_password null,'newpassword','sa'
2>go
After that try connecting using the new password for sa.
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:EC472035-7FC2-4313-8E35-626B8110E6DB@.microsoft.com...
> how would i set the sql login id and password, and what would i use my sa
password i came up with for Windows Authentication?
> "Hari Prasad" wrote:
> > Hi,
> >
> > Go to registry key
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
> > ..
> > if the value is 1 then it is NT authentication , changing the value to
2
> > would get the server into mixed mode.
> > You need to stop and start the MSSQL server services after the registry
> > change.
> >
> > See the detailed KB artticle which explains the diffrent methods to
change
> > the authentication during installation and after.
> >
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;285097
> >
> > Thanks
> > Hari
> > MCDBA
> >
> > "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> > news:D14C0B26-13BC-4479-970E-46DF471C23A6@.microsoft.com...
> > > I installed MSDE on windows server 2003 a few days ago but did not
make
> > the installation mixed mode because the documentation insisted that
Windows
> > Authentication was better. Now I am stuck with a database that I cannot
> > connect to through anything. I have tried figuring out how to switch to
> > mixed mode but documentation on MSDE is nearly nonexistent. I also
tried to
> > figure out how to uninstall a database but there is no mention of this
> > anywhere.
> > >
> > > Is there a way to switch to mixed mode, and if there is, what exactly
am I
> > supposed to do with the sa password I gave, i still haven't figured out
what
> > it is used for, and how would it be different from the sql login
> > information.
> > >
> > > I am using the database for DotNetNuke and have read that sql is a
better
> > choice than access so i'd like to give this another shot. Also how does
> > MSDE compare to the standard SQL, am I better off running access?
Thanks.
> >
> >
> >|||I can no longer start the sql database. I get two error messages when trying:
First: "The service cannot be started, either because it is disabled or because it has no enabled devices associated with it."
After clicking ok I get:
"An error 1058 - (The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.) occured while performing this service operation on the MSSQLServer service."
The key I changed was:
HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/MSSQLServer/MSSQLServer/LoginMode from 2 to 0.
"Hari Prasad" wrote:
> Hi,
> Try the below from command prompt with password as blank.
> osql -Usa -P -Sservername
> If it is not allowng login with trusteed connection using:
> OSQL -E -Sservername (enter)
> 1>sp_password null,'newpassword','sa'
> 2>go
> After that try connecting using the new password for sa.
>
> Thanks
> Hari
> MCDBA
> "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> news:EC472035-7FC2-4313-8E35-626B8110E6DB@.microsoft.com...
> > how would i set the sql login id and password, and what would i use my sa
> password i came up with for Windows Authentication?
> >
> > "Hari Prasad" wrote:
> >
> > > Hi,
> > >
> > > Go to registry key
> HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
> > > ..
> > > if the value is 1 then it is NT authentication , changing the value to
> 2
> > > would get the server into mixed mode.
> > > You need to stop and start the MSSQL server services after the registry
> > > change.
> > >
> > > See the detailed KB artticle which explains the diffrent methods to
> change
> > > the authentication during installation and after.
> > >
> > > http://support.microsoft.com/default.aspx?scid=kb;en-us;285097
> > >
> > > Thanks
> > > Hari
> > > MCDBA
> > >
> > > "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> > > news:D14C0B26-13BC-4479-970E-46DF471C23A6@.microsoft.com...
> > > > I installed MSDE on windows server 2003 a few days ago but did not
> make
> > > the installation mixed mode because the documentation insisted that
> Windows
> > > Authentication was better. Now I am stuck with a database that I cannot
> > > connect to through anything. I have tried figuring out how to switch to
> > > mixed mode but documentation on MSDE is nearly nonexistent. I also
> tried to
> > > figure out how to uninstall a database but there is no mention of this
> > > anywhere.
> > > >
> > > > Is there a way to switch to mixed mode, and if there is, what exactly
> am I
> > > supposed to do with the sa password I gave, i still haven't figured out
> what
> > > it is used for, and how would it be different from the sql login
> > > information.
> > > >
> > > > I am using the database for DotNetNuke and have read that sql is a
> better
> > > choice than access so i'd like to give this another shot. Also how does
> > > MSDE compare to the standard SQL, am I better off running access?
> Thanks.
> > >
> > >
> > >
>
>|||Hi,
The value 2 itself is Mixed mode. Can you change back the value to old and
restart the MSSQL server service.
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:42BC7C0F-D364-43C8-A512-86A537132000@.microsoft.com...
> I can no longer start the sql database. I get two error messages when
trying:
> First: "The service cannot be started, either because it is disabled or
because it has no enabled devices associated with it."
> After clicking ok I get:
> "An error 1058 - (The service cannot be started, either because it is
disabled or because it has no enabled devices associated with it.) occured
while performing this service operation on the MSSQLServer service."
> The key I changed was:
> HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/MSSQLServer/MSSQLServer/LoginMode
from 2 to 0.
> "Hari Prasad" wrote:
> > Hi,
> >
> > Try the below from command prompt with password as blank.
> >
> > osql -Usa -P -Sservername
> >
> > If it is not allowng login with trusteed connection using:
> >
> > OSQL -E -Sservername (enter)
> > 1>sp_password null,'newpassword','sa'
> > 2>go
> >
> > After that try connecting using the new password for sa.
> >
> >
> > Thanks
> > Hari
> > MCDBA
> >
> > "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> > news:EC472035-7FC2-4313-8E35-626B8110E6DB@.microsoft.com...
> > > how would i set the sql login id and password, and what would i use my
sa
> > password i came up with for Windows Authentication?
> > >
> > > "Hari Prasad" wrote:
> > >
> > > > Hi,
> > > >
> > > > Go to registry key
> > HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
> > > > ..
> > > > if the value is 1 then it is NT authentication , changing the value
to
> > 2
> > > > would get the server into mixed mode.
> > > > You need to stop and start the MSSQL server services after the
registry
> > > > change.
> > > >
> > > > See the detailed KB artticle which explains the diffrent methods to
> > change
> > > > the authentication during installation and after.
> > > >
> > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;285097
> > > >
> > > > Thanks
> > > > Hari
> > > > MCDBA
> > > >
> > > > "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> > > > news:D14C0B26-13BC-4479-970E-46DF471C23A6@.microsoft.com...
> > > > > I installed MSDE on windows server 2003 a few days ago but did not
> > make
> > > > the installation mixed mode because the documentation insisted that
> > Windows
> > > > Authentication was better. Now I am stuck with a database that I
cannot
> > > > connect to through anything. I have tried figuring out how to
switch to
> > > > mixed mode but documentation on MSDE is nearly nonexistent. I also
> > tried to
> > > > figure out how to uninstall a database but there is no mention of
this
> > > > anywhere.
> > > > >
> > > > > Is there a way to switch to mixed mode, and if there is, what
exactly
> > am I
> > > > supposed to do with the sa password I gave, i still haven't figured
out
> > what
> > > > it is used for, and how would it be different from the sql login
> > > > information.
> > > > >
> > > > > I am using the database for DotNetNuke and have read that sql is a
> > better
> > > > choice than access so i'd like to give this another shot. Also how
does
> > > > MSDE compare to the standard SQL, am I better off running access?
> > Thanks.
> > > >
> > > >
> > > >
> >
> >
> >
Is there a way to switch to mixed mode, and if there is, what exactly am I supposed to do with the sa password I gave, i still haven't figured out what it is used for, and how would it be different from the sql login information.
I am using the database for DotNetNuke and have read that sql is a better choice than access so i'd like to give this another shot. Also how does MSDE compare to the standard SQL, am I better off running access? Thanks.Hi,
Go to registry key HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
.
if the value is 1 then it is NT authentication , changing the value to 2
would get the server into mixed mode.
You need to stop and start the MSSQL server services after the registry
change.
See the detailed KB artticle which explains the diffrent methods to change
the authentication during installation and after.
http://support.microsoft.com/default.aspx?scid=kb;en-us;285097
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:D14C0B26-13BC-4479-970E-46DF471C23A6@.microsoft.com...
> I installed MSDE on windows server 2003 a few days ago but did not make
the installation mixed mode because the documentation insisted that Windows
Authentication was better. Now I am stuck with a database that I cannot
connect to through anything. I have tried figuring out how to switch to
mixed mode but documentation on MSDE is nearly nonexistent. I also tried to
figure out how to uninstall a database but there is no mention of this
anywhere.
> Is there a way to switch to mixed mode, and if there is, what exactly am I
supposed to do with the sa password I gave, i still haven't figured out what
it is used for, and how would it be different from the sql login
information.
> I am using the database for DotNetNuke and have read that sql is a better
choice than access so i'd like to give this another shot. Also how does
MSDE compare to the standard SQL, am I better off running access? Thanks.|||how would i set the sql login id and password, and what would i use my sa password i came up with for Windows Authentication?
"Hari Prasad" wrote:
> Hi,
> Go to registry key HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
> ..
> if the value is 1 then it is NT authentication , changing the value to 2
> would get the server into mixed mode.
> You need to stop and start the MSSQL server services after the registry
> change.
> See the detailed KB artticle which explains the diffrent methods to change
> the authentication during installation and after.
> http://support.microsoft.com/default.aspx?scid=kb;en-us;285097
> Thanks
> Hari
> MCDBA
> "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> news:D14C0B26-13BC-4479-970E-46DF471C23A6@.microsoft.com...
> > I installed MSDE on windows server 2003 a few days ago but did not make
> the installation mixed mode because the documentation insisted that Windows
> Authentication was better. Now I am stuck with a database that I cannot
> connect to through anything. I have tried figuring out how to switch to
> mixed mode but documentation on MSDE is nearly nonexistent. I also tried to
> figure out how to uninstall a database but there is no mention of this
> anywhere.
> >
> > Is there a way to switch to mixed mode, and if there is, what exactly am I
> supposed to do with the sa password I gave, i still haven't figured out what
> it is used for, and how would it be different from the sql login
> information.
> >
> > I am using the database for DotNetNuke and have read that sql is a better
> choice than access so i'd like to give this another shot. Also how does
> MSDE compare to the standard SQL, am I better off running access? Thanks.
>
>|||Hi,
Try the below from command prompt with password as blank.
osql -Usa -P -Sservername
If it is not allowng login with trusteed connection using:
OSQL -E -Sservername (enter)
1>sp_password null,'newpassword','sa'
2>go
After that try connecting using the new password for sa.
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:EC472035-7FC2-4313-8E35-626B8110E6DB@.microsoft.com...
> how would i set the sql login id and password, and what would i use my sa
password i came up with for Windows Authentication?
> "Hari Prasad" wrote:
> > Hi,
> >
> > Go to registry key
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
> > ..
> > if the value is 1 then it is NT authentication , changing the value to
2
> > would get the server into mixed mode.
> > You need to stop and start the MSSQL server services after the registry
> > change.
> >
> > See the detailed KB artticle which explains the diffrent methods to
change
> > the authentication during installation and after.
> >
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;285097
> >
> > Thanks
> > Hari
> > MCDBA
> >
> > "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> > news:D14C0B26-13BC-4479-970E-46DF471C23A6@.microsoft.com...
> > > I installed MSDE on windows server 2003 a few days ago but did not
make
> > the installation mixed mode because the documentation insisted that
Windows
> > Authentication was better. Now I am stuck with a database that I cannot
> > connect to through anything. I have tried figuring out how to switch to
> > mixed mode but documentation on MSDE is nearly nonexistent. I also
tried to
> > figure out how to uninstall a database but there is no mention of this
> > anywhere.
> > >
> > > Is there a way to switch to mixed mode, and if there is, what exactly
am I
> > supposed to do with the sa password I gave, i still haven't figured out
what
> > it is used for, and how would it be different from the sql login
> > information.
> > >
> > > I am using the database for DotNetNuke and have read that sql is a
better
> > choice than access so i'd like to give this another shot. Also how does
> > MSDE compare to the standard SQL, am I better off running access?
Thanks.
> >
> >
> >|||I can no longer start the sql database. I get two error messages when trying:
First: "The service cannot be started, either because it is disabled or because it has no enabled devices associated with it."
After clicking ok I get:
"An error 1058 - (The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.) occured while performing this service operation on the MSSQLServer service."
The key I changed was:
HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/MSSQLServer/MSSQLServer/LoginMode from 2 to 0.
"Hari Prasad" wrote:
> Hi,
> Try the below from command prompt with password as blank.
> osql -Usa -P -Sservername
> If it is not allowng login with trusteed connection using:
> OSQL -E -Sservername (enter)
> 1>sp_password null,'newpassword','sa'
> 2>go
> After that try connecting using the new password for sa.
>
> Thanks
> Hari
> MCDBA
> "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> news:EC472035-7FC2-4313-8E35-626B8110E6DB@.microsoft.com...
> > how would i set the sql login id and password, and what would i use my sa
> password i came up with for Windows Authentication?
> >
> > "Hari Prasad" wrote:
> >
> > > Hi,
> > >
> > > Go to registry key
> HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
> > > ..
> > > if the value is 1 then it is NT authentication , changing the value to
> 2
> > > would get the server into mixed mode.
> > > You need to stop and start the MSSQL server services after the registry
> > > change.
> > >
> > > See the detailed KB artticle which explains the diffrent methods to
> change
> > > the authentication during installation and after.
> > >
> > > http://support.microsoft.com/default.aspx?scid=kb;en-us;285097
> > >
> > > Thanks
> > > Hari
> > > MCDBA
> > >
> > > "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> > > news:D14C0B26-13BC-4479-970E-46DF471C23A6@.microsoft.com...
> > > > I installed MSDE on windows server 2003 a few days ago but did not
> make
> > > the installation mixed mode because the documentation insisted that
> Windows
> > > Authentication was better. Now I am stuck with a database that I cannot
> > > connect to through anything. I have tried figuring out how to switch to
> > > mixed mode but documentation on MSDE is nearly nonexistent. I also
> tried to
> > > figure out how to uninstall a database but there is no mention of this
> > > anywhere.
> > > >
> > > > Is there a way to switch to mixed mode, and if there is, what exactly
> am I
> > > supposed to do with the sa password I gave, i still haven't figured out
> what
> > > it is used for, and how would it be different from the sql login
> > > information.
> > > >
> > > > I am using the database for DotNetNuke and have read that sql is a
> better
> > > choice than access so i'd like to give this another shot. Also how does
> > > MSDE compare to the standard SQL, am I better off running access?
> Thanks.
> > >
> > >
> > >
>
>|||Hi,
The value 2 itself is Mixed mode. Can you change back the value to old and
restart the MSSQL server service.
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:42BC7C0F-D364-43C8-A512-86A537132000@.microsoft.com...
> I can no longer start the sql database. I get two error messages when
trying:
> First: "The service cannot be started, either because it is disabled or
because it has no enabled devices associated with it."
> After clicking ok I get:
> "An error 1058 - (The service cannot be started, either because it is
disabled or because it has no enabled devices associated with it.) occured
while performing this service operation on the MSSQLServer service."
> The key I changed was:
> HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/MSSQLServer/MSSQLServer/LoginMode
from 2 to 0.
> "Hari Prasad" wrote:
> > Hi,
> >
> > Try the below from command prompt with password as blank.
> >
> > osql -Usa -P -Sservername
> >
> > If it is not allowng login with trusteed connection using:
> >
> > OSQL -E -Sservername (enter)
> > 1>sp_password null,'newpassword','sa'
> > 2>go
> >
> > After that try connecting using the new password for sa.
> >
> >
> > Thanks
> > Hari
> > MCDBA
> >
> > "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> > news:EC472035-7FC2-4313-8E35-626B8110E6DB@.microsoft.com...
> > > how would i set the sql login id and password, and what would i use my
sa
> > password i came up with for Windows Authentication?
> > >
> > > "Hari Prasad" wrote:
> > >
> > > > Hi,
> > > >
> > > > Go to registry key
> > HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
> > > > ..
> > > > if the value is 1 then it is NT authentication , changing the value
to
> > 2
> > > > would get the server into mixed mode.
> > > > You need to stop and start the MSSQL server services after the
registry
> > > > change.
> > > >
> > > > See the detailed KB artticle which explains the diffrent methods to
> > change
> > > > the authentication during installation and after.
> > > >
> > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;285097
> > > >
> > > > Thanks
> > > > Hari
> > > > MCDBA
> > > >
> > > > "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> > > > news:D14C0B26-13BC-4479-970E-46DF471C23A6@.microsoft.com...
> > > > > I installed MSDE on windows server 2003 a few days ago but did not
> > make
> > > > the installation mixed mode because the documentation insisted that
> > Windows
> > > > Authentication was better. Now I am stuck with a database that I
cannot
> > > > connect to through anything. I have tried figuring out how to
switch to
> > > > mixed mode but documentation on MSDE is nearly nonexistent. I also
> > tried to
> > > > figure out how to uninstall a database but there is no mention of
this
> > > > anywhere.
> > > > >
> > > > > Is there a way to switch to mixed mode, and if there is, what
exactly
> > am I
> > > > supposed to do with the sa password I gave, i still haven't figured
out
> > what
> > > > it is used for, and how would it be different from the sql login
> > > > information.
> > > > >
> > > > > I am using the database for DotNetNuke and have read that sql is a
> > better
> > > > choice than access so i'd like to give this another shot. Also how
does
> > > > MSDE compare to the standard SQL, am I better off running access?
> > Thanks.
> > > >
> > > >
> > > >
> >
> >
> >
Converting MSDE databse to mixed mode
I installed MSDE on windows server 2003 a few days ago but did not make the
installation mixed mode because the documentation insisted that Windows Auth
entication was better. Now I am stuck with a database that I cannot connect
to through anything. I ha
ve tried figuring out how to switch to mixed mode but documentation on MSDE
is nearly nonexistent. I also tried to figure out how to uninstall a databa
se but there is no mention of this anywhere.
Is there a way to switch to mixed mode, and if there is, what exactly am I s
upposed to do with the sa password I gave, i still haven't figured out what
it is used for, and how would it be different from the sql login information
.
I am using the database for DotNetNuke and have read that sql is a better ch
oice than access so i'd like to give this another shot. Also how does MSDE
compare to the standard SQL, am I better off running access? Thanks.Hi,
Go to registry key HKLM\Software\Microsoft\MSSqlserver\MSSq
lServer\LoginMode
.
if the value is 1 then it is NT authentication , changing the value to 2
would get the server into mixed mode.
You need to stop and start the MSSQL server services after the registry
change.
See the detailed KB artticle which explains the diffrent methods to change
the authentication during installation and after.
http://support.microsoft.com/defaul...kb;en-us;285097
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:D14C0B26-13BC-4479-970E-46DF471C23A6@.microsoft.com...
> I installed MSDE on windows server 2003 a few days ago but did not make
the installation mixed mode because the documentation insisted that Windows
Authentication was better. Now I am stuck with a database that I cannot
connect to through anything. I have tried figuring out how to switch to
mixed mode but documentation on MSDE is nearly nonexistent. I also tried to
figure out how to uninstall a database but there is no mention of this
anywhere.
> Is there a way to switch to mixed mode, and if there is, what exactly am I
supposed to do with the sa password I gave, i still haven't figured out what
it is used for, and how would it be different from the sql login
information.
> I am using the database for DotNetNuke and have read that sql is a better
choice than access so i'd like to give this another shot. Also how does
MSDE compare to the standard SQL, am I better off running access? Thanks.|||how would i set the sql login id and password, and what would i use my sa pa
ssword i came up with for Windows Authentication?
"Hari Prasad" wrote:
> Hi,
> Go to registry key HKLM\Software\Microsoft\MSSqlserver\MSSq
lServer\LoginMo
de
> ..
> if the value is 1 then it is NT authentication , changing the value to 2
> would get the server into mixed mode.
> You need to stop and start the MSSQL server services after the registry
> change.
> See the detailed KB artticle which explains the diffrent methods to change
> the authentication during installation and after.
> http://support.microsoft.com/defaul...kb;en-us;285097
> Thanks
> Hari
> MCDBA
> "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> news:D14C0B26-13BC-4479-970E-46DF471C23A6@.microsoft.com...
> the installation mixed mode because the documentation insisted that Window
s
> Authentication was better. Now I am stuck with a database that I cannot
> connect to through anything. I have tried figuring out how to switch to
> mixed mode but documentation on MSDE is nearly nonexistent. I also tried
to
> figure out how to uninstall a database but there is no mention of this
> anywhere.
> supposed to do with the sa password I gave, i still haven't figured out wh
at
> it is used for, and how would it be different from the sql login
> information.
> choice than access so i'd like to give this another shot. Also how does
> MSDE compare to the standard SQL, am I better off running access? Thanks.
>
>|||Hi,
Try the below from command prompt with password as blank.
osql -Usa -P -Sservername
If it is not allowng login with trusteed connection using:
OSQL -E -Sservername (enter)
1>sp_password null,'newpassword','sa'
2>go
After that try connecting using the new password for sa.
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:EC472035-7FC2-4313-8E35-626B8110E6DB@.microsoft.com...
> how would i set the sql login id and password, and what would i use my sa
password i came up with for Windows Authentication?[vbcol=seagreen]
> "Hari Prasad" wrote:
>
HKLM\Software\Microsoft\MSSqlserver\MSSq
lServer\LoginMode[vbcol=seagreen]
2[vbcol=seagreen]
change[vbcol=seagreen]
make[vbcol=seagreen]
Windows[vbcol=seagreen]
tried to[vbcol=seagreen]
am I[vbcol=seagreen]
what[vbcol=seagreen]
better[vbcol=seagreen]
Thanks.[vbcol=seagreen]|||I can no longer start the sql database. I get two error messages when tryin
g:
First: "The service cannot be started, either because it is disabled or beca
use it has no enabled devices associated with it."
After clicking ok I get:
"An error 1058 - (The service cannot be started, either because it is disabl
ed or because it has no enabled devices associated with it.) occured while p
erforming this service operation on the MSSQLServer service."
The key I changed was:
HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/MSSQLServer/MSSQLServer/LoginMode from
2 to 0.
"Hari Prasad" wrote:
> Hi,
> Try the below from command prompt with password as blank.
> osql -Usa -P -Sservername
> If it is not allowng login with trusteed connection using:
> OSQL -E -Sservername (enter)
> 1>sp_password null,'newpassword','sa'
> 2>go
> After that try connecting using the new password for sa.
>
> Thanks
> Hari
> MCDBA
> "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> news:EC472035-7FC2-4313-8E35-626B8110E6DB@.microsoft.com...
> password i came up with for Windows Authentication?
> HKLM\Software\Microsoft\MSSqlserver\MSSq
lServer\LoginMode
> 2
> change
> make
> Windows
> tried to
> am I
> what
> better
> Thanks.
>
>|||Hi,
The value 2 itself is Mixed mode. Can you change back the value to old and
restart the MSSQL server service.
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:42BC7C0F-D364-43C8-A512-86A537132000@.microsoft.com...
> I can no longer start the sql database. I get two error messages when
trying:
> First: "The service cannot be started, either because it is disabled or
because it has no enabled devices associated with it."
> After clicking ok I get:
> "An error 1058 - (The service cannot be started, either because it is
disabled or because it has no enabled devices associated with it.) occured
while performing this service operation on the MSSQLServer service."
> The key I changed was:
> HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/MSSQLServer/MSSQLServer/LoginMode
from 2 to 0.[vbcol=seagreen]
> "Hari Prasad" wrote:
>
sa[vbcol=seagreen]
to[vbcol=seagreen]
registry[vbcol=seagreen]
cannot[vbcol=seagreen]
switch to[vbcol=seagreen]
this[vbcol=seagreen]
exactly[vbcol=seagreen]
out[vbcol=seagreen]
does[vbcol=seagreen]|||ok thank you, i got it to work and changed the sa password. Was this necess
ary if I had installed it with SAPWD="password." Should I create a new user
account for use with my dotnetnuke portal or should i just use the sa accou
nt? Also why do I keep rea
ding everywhere that Windows Authentication is better yet it doesn't explain
how to have anonymous users from the net use it, was Windows Authentication
designed only for intranet. Thanks again. on a side note what's the purpo
se of the null in the comma
nd you posted last? Is there a site that lists the osql commands in detail?
"Hari Prasad" wrote:
> Hi,
>
> The value 2 itself is Mixed mode. Can you change back the value to old and
> restart the MSSQL server service.
> Thanks
> Hari
> MCDBA
> "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> news:42BC7C0F-D364-43C8-A512-86A537132000@.microsoft.com...
> trying:
> because it has no enabled devices associated with it."
> disabled or because it has no enabled devices associated with it.) occured
> while performing this service operation on the MSSQLServer service."
> from 2 to 0.
> sa
> to
> registry
> cannot
> switch to
> this
> exactly
> out
> does
>
>
installation mixed mode because the documentation insisted that Windows Auth
entication was better. Now I am stuck with a database that I cannot connect
to through anything. I ha
ve tried figuring out how to switch to mixed mode but documentation on MSDE
is nearly nonexistent. I also tried to figure out how to uninstall a databa
se but there is no mention of this anywhere.
Is there a way to switch to mixed mode, and if there is, what exactly am I s
upposed to do with the sa password I gave, i still haven't figured out what
it is used for, and how would it be different from the sql login information
.
I am using the database for DotNetNuke and have read that sql is a better ch
oice than access so i'd like to give this another shot. Also how does MSDE
compare to the standard SQL, am I better off running access? Thanks.Hi,
Go to registry key HKLM\Software\Microsoft\MSSqlserver\MSSq
lServer\LoginMode
.
if the value is 1 then it is NT authentication , changing the value to 2
would get the server into mixed mode.
You need to stop and start the MSSQL server services after the registry
change.
See the detailed KB artticle which explains the diffrent methods to change
the authentication during installation and after.
http://support.microsoft.com/defaul...kb;en-us;285097
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:D14C0B26-13BC-4479-970E-46DF471C23A6@.microsoft.com...
> I installed MSDE on windows server 2003 a few days ago but did not make
the installation mixed mode because the documentation insisted that Windows
Authentication was better. Now I am stuck with a database that I cannot
connect to through anything. I have tried figuring out how to switch to
mixed mode but documentation on MSDE is nearly nonexistent. I also tried to
figure out how to uninstall a database but there is no mention of this
anywhere.
> Is there a way to switch to mixed mode, and if there is, what exactly am I
supposed to do with the sa password I gave, i still haven't figured out what
it is used for, and how would it be different from the sql login
information.
> I am using the database for DotNetNuke and have read that sql is a better
choice than access so i'd like to give this another shot. Also how does
MSDE compare to the standard SQL, am I better off running access? Thanks.|||how would i set the sql login id and password, and what would i use my sa pa
ssword i came up with for Windows Authentication?
"Hari Prasad" wrote:
> Hi,
> Go to registry key HKLM\Software\Microsoft\MSSqlserver\MSSq
lServer\LoginMo
de
> ..
> if the value is 1 then it is NT authentication , changing the value to 2
> would get the server into mixed mode.
> You need to stop and start the MSSQL server services after the registry
> change.
> See the detailed KB artticle which explains the diffrent methods to change
> the authentication during installation and after.
> http://support.microsoft.com/defaul...kb;en-us;285097
> Thanks
> Hari
> MCDBA
> "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> news:D14C0B26-13BC-4479-970E-46DF471C23A6@.microsoft.com...
> the installation mixed mode because the documentation insisted that Window
s
> Authentication was better. Now I am stuck with a database that I cannot
> connect to through anything. I have tried figuring out how to switch to
> mixed mode but documentation on MSDE is nearly nonexistent. I also tried
to
> figure out how to uninstall a database but there is no mention of this
> anywhere.
> supposed to do with the sa password I gave, i still haven't figured out wh
at
> it is used for, and how would it be different from the sql login
> information.
> choice than access so i'd like to give this another shot. Also how does
> MSDE compare to the standard SQL, am I better off running access? Thanks.
>
>|||Hi,
Try the below from command prompt with password as blank.
osql -Usa -P -Sservername
If it is not allowng login with trusteed connection using:
OSQL -E -Sservername (enter)
1>sp_password null,'newpassword','sa'
2>go
After that try connecting using the new password for sa.
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:EC472035-7FC2-4313-8E35-626B8110E6DB@.microsoft.com...
> how would i set the sql login id and password, and what would i use my sa
password i came up with for Windows Authentication?[vbcol=seagreen]
> "Hari Prasad" wrote:
>
HKLM\Software\Microsoft\MSSqlserver\MSSq
lServer\LoginMode[vbcol=seagreen]
2[vbcol=seagreen]
change[vbcol=seagreen]
make[vbcol=seagreen]
Windows[vbcol=seagreen]
tried to[vbcol=seagreen]
am I[vbcol=seagreen]
what[vbcol=seagreen]
better[vbcol=seagreen]
Thanks.[vbcol=seagreen]|||I can no longer start the sql database. I get two error messages when tryin
g:
First: "The service cannot be started, either because it is disabled or beca
use it has no enabled devices associated with it."
After clicking ok I get:
"An error 1058 - (The service cannot be started, either because it is disabl
ed or because it has no enabled devices associated with it.) occured while p
erforming this service operation on the MSSQLServer service."
The key I changed was:
HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/MSSQLServer/MSSQLServer/LoginMode from
2 to 0.
"Hari Prasad" wrote:
> Hi,
> Try the below from command prompt with password as blank.
> osql -Usa -P -Sservername
> If it is not allowng login with trusteed connection using:
> OSQL -E -Sservername (enter)
> 1>sp_password null,'newpassword','sa'
> 2>go
> After that try connecting using the new password for sa.
>
> Thanks
> Hari
> MCDBA
> "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> news:EC472035-7FC2-4313-8E35-626B8110E6DB@.microsoft.com...
> password i came up with for Windows Authentication?
> HKLM\Software\Microsoft\MSSqlserver\MSSq
lServer\LoginMode
> 2
> change
> make
> Windows
> tried to
> am I
> what
> better
> Thanks.
>
>|||Hi,
The value 2 itself is Mixed mode. Can you change back the value to old and
restart the MSSQL server service.
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:42BC7C0F-D364-43C8-A512-86A537132000@.microsoft.com...
> I can no longer start the sql database. I get two error messages when
trying:
> First: "The service cannot be started, either because it is disabled or
because it has no enabled devices associated with it."
> After clicking ok I get:
> "An error 1058 - (The service cannot be started, either because it is
disabled or because it has no enabled devices associated with it.) occured
while performing this service operation on the MSSQLServer service."
> The key I changed was:
> HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/MSSQLServer/MSSQLServer/LoginMode
from 2 to 0.[vbcol=seagreen]
> "Hari Prasad" wrote:
>
sa[vbcol=seagreen]
to[vbcol=seagreen]
registry[vbcol=seagreen]
cannot[vbcol=seagreen]
switch to[vbcol=seagreen]
this[vbcol=seagreen]
exactly[vbcol=seagreen]
out[vbcol=seagreen]
does[vbcol=seagreen]|||ok thank you, i got it to work and changed the sa password. Was this necess
ary if I had installed it with SAPWD="password." Should I create a new user
account for use with my dotnetnuke portal or should i just use the sa accou
nt? Also why do I keep rea
ding everywhere that Windows Authentication is better yet it doesn't explain
how to have anonymous users from the net use it, was Windows Authentication
designed only for intranet. Thanks again. on a side note what's the purpo
se of the null in the comma
nd you posted last? Is there a site that lists the osql commands in detail?
"Hari Prasad" wrote:
> Hi,
>
> The value 2 itself is Mixed mode. Can you change back the value to old and
> restart the MSSQL server service.
> Thanks
> Hari
> MCDBA
> "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> news:42BC7C0F-D364-43C8-A512-86A537132000@.microsoft.com...
> trying:
> because it has no enabled devices associated with it."
> disabled or because it has no enabled devices associated with it.) occured
> while performing this service operation on the MSSQLServer service."
> from 2 to 0.
> sa
> to
> registry
> cannot
> switch to
> this
> exactly
> out
> does
>
>
Converting MS Access to SQL Server 2K
Hi,
I am fairly new to SQL Server and would appreciate if anyone could solve my
problem.
I have SQL server 2k installed on the server, say server1. My website is
also hosted on the same server. I have another instance installed on my
client machine.
Now I am connecting to the remote SQL server instance and
migrating/importing data from MS Access DB. The database migrated
successfully. I changed the ADO connection properties in my ASP code to
access data from SQL server.
Now the problem...
1) I am connecting to the DB but have to prefix all my table names with the
DBO, eg.. [DBO].tablename. Is there any way I can avoid this?
2) Also the recordset does not return any record
please help
regards
Using the 2-part name is optional... When you select * from mytable. SQL
first looks to see if YOU own a table with that name. ( ie wayne.mytable).
If such a table does NOT exist, then it searches for and returns a table
like this owned by the dbo... ( ie dbo.mytable)...
So you shouldn't have to use the 2-part name...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Fuzail" <Fuzail@.discussions.microsoft.com> wrote in message
news:AB8DC0C4-29A8-48A1-99AC-B89F9668DBDA@.microsoft.com...
> Hi,
> I am fairly new to SQL Server and would appreciate if anyone could solve
my
> problem.
> I have SQL server 2k installed on the server, say server1. My website is
> also hosted on the same server. I have another instance installed on my
> client machine.
> Now I am connecting to the remote SQL server instance and
> migrating/importing data from MS Access DB. The database migrated
> successfully. I changed the ADO connection properties in my ASP code to
> access data from SQL server.
> Now the problem...
> 1) I am connecting to the DB but have to prefix all my table names with
the
> DBO, eg.. [DBO].tablename. Is there any way I can avoid this?
> 2) Also the recordset does not return any record
> please help
> regards
|||
>2) Also the recordset does not return any record
what is your query, and what is the dB structure?
I am fairly new to SQL Server and would appreciate if anyone could solve my
problem.
I have SQL server 2k installed on the server, say server1. My website is
also hosted on the same server. I have another instance installed on my
client machine.
Now I am connecting to the remote SQL server instance and
migrating/importing data from MS Access DB. The database migrated
successfully. I changed the ADO connection properties in my ASP code to
access data from SQL server.
Now the problem...
1) I am connecting to the DB but have to prefix all my table names with the
DBO, eg.. [DBO].tablename. Is there any way I can avoid this?
2) Also the recordset does not return any record
please help
regards
Using the 2-part name is optional... When you select * from mytable. SQL
first looks to see if YOU own a table with that name. ( ie wayne.mytable).
If such a table does NOT exist, then it searches for and returns a table
like this owned by the dbo... ( ie dbo.mytable)...
So you shouldn't have to use the 2-part name...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Fuzail" <Fuzail@.discussions.microsoft.com> wrote in message
news:AB8DC0C4-29A8-48A1-99AC-B89F9668DBDA@.microsoft.com...
> Hi,
> I am fairly new to SQL Server and would appreciate if anyone could solve
my
> problem.
> I have SQL server 2k installed on the server, say server1. My website is
> also hosted on the same server. I have another instance installed on my
> client machine.
> Now I am connecting to the remote SQL server instance and
> migrating/importing data from MS Access DB. The database migrated
> successfully. I changed the ADO connection properties in my ASP code to
> access data from SQL server.
> Now the problem...
> 1) I am connecting to the DB but have to prefix all my table names with
the
> DBO, eg.. [DBO].tablename. Is there any way I can avoid this?
> 2) Also the recordset does not return any record
> please help
> regards
|||
>2) Also the recordset does not return any record
what is your query, and what is the dB structure?
Converting MS Access to SQL Server 2K
Hi,
I am fairly new to SQL Server and would appreciate if anyone could solve my
problem.
I have SQL server 2k installed on the server, say server1. My website is
also hosted on the same server. I have another instance installed on my
client machine.
Now I am connecting to the remote SQL server instance and
migrating/importing data from MS Access DB. The database migrated
successfully. I changed the ADO connection properties in my ASP code to
access data from SQL server.
Now the problem...
1) I am connecting to the DB but have to prefix all my table names with the
DBO, eg.. [DBO].tablename. Is there any way I can avoid this?
2) Also the recordset does not return any record
please help
regardsUsing the 2-part name is optional... When you select * from mytable. SQL
first looks to see if YOU own a table with that name. ( ie wayne.mytable).
If such a table does NOT exist, then it searches for and returns a table
like this owned by the dbo... ( ie dbo.mytable)...
So you shouldn't have to use the 2-part name...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Fuzail" <Fuzail@.discussions.microsoft.com> wrote in message
news:AB8DC0C4-29A8-48A1-99AC-B89F9668DBDA@.microsoft.com...
> Hi,
> I am fairly new to SQL Server and would appreciate if anyone could solve
my
> problem.
> I have SQL server 2k installed on the server, say server1. My website is
> also hosted on the same server. I have another instance installed on my
> client machine.
> Now I am connecting to the remote SQL server instance and
> migrating/importing data from MS Access DB. The database migrated
> successfully. I changed the ADO connection properties in my ASP code to
> access data from SQL server.
> Now the problem...
> 1) I am connecting to the DB but have to prefix all my table names with
the
> DBO, eg.. [DBO].tablename. Is there any way I can avoid this?
> 2) Also the recordset does not return any record
> please help
> regards|||>2) Also the recordset does not return any record
what is your query, and what is the dB structure?
I am fairly new to SQL Server and would appreciate if anyone could solve my
problem.
I have SQL server 2k installed on the server, say server1. My website is
also hosted on the same server. I have another instance installed on my
client machine.
Now I am connecting to the remote SQL server instance and
migrating/importing data from MS Access DB. The database migrated
successfully. I changed the ADO connection properties in my ASP code to
access data from SQL server.
Now the problem...
1) I am connecting to the DB but have to prefix all my table names with the
DBO, eg.. [DBO].tablename. Is there any way I can avoid this?
2) Also the recordset does not return any record
please help
regardsUsing the 2-part name is optional... When you select * from mytable. SQL
first looks to see if YOU own a table with that name. ( ie wayne.mytable).
If such a table does NOT exist, then it searches for and returns a table
like this owned by the dbo... ( ie dbo.mytable)...
So you shouldn't have to use the 2-part name...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Fuzail" <Fuzail@.discussions.microsoft.com> wrote in message
news:AB8DC0C4-29A8-48A1-99AC-B89F9668DBDA@.microsoft.com...
> Hi,
> I am fairly new to SQL Server and would appreciate if anyone could solve
my
> problem.
> I have SQL server 2k installed on the server, say server1. My website is
> also hosted on the same server. I have another instance installed on my
> client machine.
> Now I am connecting to the remote SQL server instance and
> migrating/importing data from MS Access DB. The database migrated
> successfully. I changed the ADO connection properties in my ASP code to
> access data from SQL server.
> Now the problem...
> 1) I am connecting to the DB but have to prefix all my table names with
the
> DBO, eg.. [DBO].tablename. Is there any way I can avoid this?
> 2) Also the recordset does not return any record
> please help
> regards|||>2) Also the recordset does not return any record
what is your query, and what is the dB structure?
Converting MS Access to SQL Server 2K
Hi,
I am fairly new to SQL Server and would appreciate if anyone could solve my
problem.
I have SQL server 2k installed on the server, say server1. My website is
also hosted on the same server. I have another instance installed on my
client machine.
Now I am connecting to the remote SQL server instance and
migrating/importing data from MS Access DB. The database migrated
successfully. I changed the ADO connection properties in my ASP code to
access data from SQL server.
Now the problem...
1) I am connecting to the DB but have to prefix all my table names with the
DBO, eg.. [DBO].tablename. Is there any way I can avoid this?
2) Also the recordset does not return any record
please help
regardsUsing the 2-part name is optional... When you select * from mytable. SQL
first looks to see if YOU own a table with that name. ( ie wayne.mytable).
If such a table does NOT exist, then it searches for and returns a table
like this owned by the dbo... ( ie dbo.mytable)...
So you shouldn't have to use the 2-part name...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Fuzail" <Fuzail@.discussions.microsoft.com> wrote in message
news:AB8DC0C4-29A8-48A1-99AC-B89F9668DBDA@.microsoft.com...
> Hi,
> I am fairly new to SQL Server and would appreciate if anyone could solve
my
> problem.
> I have SQL server 2k installed on the server, say server1. My website is
> also hosted on the same server. I have another instance installed on my
> client machine.
> Now I am connecting to the remote SQL server instance and
> migrating/importing data from MS Access DB. The database migrated
> successfully. I changed the ADO connection properties in my ASP code to
> access data from SQL server.
> Now the problem...
> 1) I am connecting to the DB but have to prefix all my table names with
the
> DBO, eg.. [DBO].tablename. Is there any way I can avoid this?
> 2) Also the recordset does not return any record
> please help
> regards|||
>2) Also the recordset does not return any record
what is your query, and what is the dB structure?
I am fairly new to SQL Server and would appreciate if anyone could solve my
problem.
I have SQL server 2k installed on the server, say server1. My website is
also hosted on the same server. I have another instance installed on my
client machine.
Now I am connecting to the remote SQL server instance and
migrating/importing data from MS Access DB. The database migrated
successfully. I changed the ADO connection properties in my ASP code to
access data from SQL server.
Now the problem...
1) I am connecting to the DB but have to prefix all my table names with the
DBO, eg.. [DBO].tablename. Is there any way I can avoid this?
2) Also the recordset does not return any record
please help
regardsUsing the 2-part name is optional... When you select * from mytable. SQL
first looks to see if YOU own a table with that name. ( ie wayne.mytable).
If such a table does NOT exist, then it searches for and returns a table
like this owned by the dbo... ( ie dbo.mytable)...
So you shouldn't have to use the 2-part name...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Fuzail" <Fuzail@.discussions.microsoft.com> wrote in message
news:AB8DC0C4-29A8-48A1-99AC-B89F9668DBDA@.microsoft.com...
> Hi,
> I am fairly new to SQL Server and would appreciate if anyone could solve
my
> problem.
> I have SQL server 2k installed on the server, say server1. My website is
> also hosted on the same server. I have another instance installed on my
> client machine.
> Now I am connecting to the remote SQL server instance and
> migrating/importing data from MS Access DB. The database migrated
> successfully. I changed the ADO connection properties in my ASP code to
> access data from SQL server.
> Now the problem...
> 1) I am connecting to the DB but have to prefix all my table names with
the
> DBO, eg.. [DBO].tablename. Is there any way I can avoid this?
> 2) Also the recordset does not return any record
> please help
> regards|||
>2) Also the recordset does not return any record
what is your query, and what is the dB structure?
Subscribe to:
Posts (Atom)