After changing the startup parameters and moving the database we are unable
to start SQL. The error message we are getting in the application log is
that the initconfig: (error 5) access denied to g:\sqldata.
HI,
How u moved the database and what parameter u have changed.
from
killer
Ray Skweres wrote:
> After changing the startup parameters and moving the database we are unable
> to start SQL. The error message we are getting in the application log is
> that the initconfig: (error 5) access denied to g:\sqldata.
|||Hi
This article descibes how to move your master database
http://support.microsoft.com/kb/224071/EN-US/
You may want to try starting SQL Server from the command prompt
http://msdn.microsoft.com/library/de...servr_4apa.asp
with the correct parameters (possibly with -f also!) and also making sure
that the permissions for the directories being used are correct.
You can not use a mapped network drive for your database files.
John
"Ray Skweres" wrote:
> After changing the startup parameters and moving the database we are unable
> to start SQL. The error message we are getting in the application log is
> that the initconfig: (error 5) access denied to g:\sqldata.
|||Error 5 is access denied. Make sure that the SQL Server service account has permissions to the file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ray Skweres" <RaySkweres@.discussions.microsoft.com> wrote in message
news:2053CEEC-32D3-4840-9898-D59433C29617@.microsoft.com...
> After changing the startup parameters and moving the database we are unable
> to start SQL. The error message we are getting in the application log is
> that the initconfig: (error 5) access denied to g:\sqldata.
|||Moved it based on Microsoft articel changed startup parameters and only moved
the master.mdf so I only changed that parameter.
"doller" wrote:
> HI,
> How u moved the database and what parameter u have changed.
> from
> killer
>
> Ray Skweres wrote:
>
|||Used this article to move the database also tried to start it from a command
prompt and would not start. Also tried to change the startup parameters back
though command prompt and did not work. I am not using a mapped network
drive. Permissions are fine on the file. Even went into registry and tried
to change and then start sql still did not start and then when I went back
into the registry and it was back to the old setting.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> This article descibes how to move your master database
> http://support.microsoft.com/kb/224071/EN-US/
> You may want to try starting SQL Server from the command prompt
> http://msdn.microsoft.com/library/de...servr_4apa.asp
> with the correct parameters (possibly with -f also!) and also making sure
> that the permissions for the directories being used are correct.
> You can not use a mapped network drive for your database files.
> John
> "Ray Skweres" wrote:
|||Hi
Are you using the -d and -l parameters when starting on the command prompt?
Is there any privacy or anti-virus software running?
You may want to try reverting back to the previous location and see if it
starts.
If have backed up all your databases then you may want to try un-installing
and re-installing. You should be able to attach the databases from the
mdf/ldf files, but you will need to re-instate logins and jobs.
John
"Ray Skweres" wrote:
[vbcol=seagreen]
> Used this article to move the database also tried to start it from a command
> prompt and would not start. Also tried to change the startup parameters back
> though command prompt and did not work. I am not using a mapped network
> drive. Permissions are fine on the file. Even went into registry and tried
> to change and then start sql still did not start and then when I went back
> into the registry and it was back to the old setting.
> "John Bell" wrote:
|||Whether your the service account you are starting has access to the
g:\sqldata.
Thanks
Ajay Rengunthwar
MCDBA, MCAD
"Ray Skweres" <RaySkweres@.discussions.microsoft.com> wrote in message
news:19FD3DAA-35C5-482E-B0CD-FA8068B7FA71@.microsoft.com...
> Moved it based on Microsoft articel changed startup parameters and only
moved[vbcol=seagreen]
> the master.mdf so I only changed that parameter.
> "doller" wrote:
unable[vbcol=seagreen]
log is[vbcol=seagreen]
|||Hi
Another thought, have you checked for disc corruption?
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:BFC7ACBD-19F4-4714-919B-C7774A17FFC7@.microsoft.com...[vbcol=seagreen]
> Hi
> Are you using the -d and -l parameters when starting on the command
> prompt?
> Is there any privacy or anti-virus software running?
> You may want to try reverting back to the previous location and see if it
> starts.
> If have backed up all your databases then you may want to try
> un-installing
> and re-installing. You should be able to attach the databases from the
> mdf/ldf files, but you will need to re-instate logins and jobs.
>
> John
> "Ray Skweres" wrote:
Showing posts with label startup. Show all posts
Showing posts with label startup. Show all posts
Friday, March 23, 2012
Moved master db and now cannot start SQL
After changing the startup parameters and moving the database we are unable
to start SQL. The error message we are getting in the application log is
that the initconfig: (error 5) access denied to g:\sqldata.HI,
How u moved the database and what parameter u have changed.
from
killer
Ray Skweres wrote:
> After changing the startup parameters and moving the database we are unabl
e
> to start SQL. The error message we are getting in the application log is
> that the initconfig: (error 5) access denied to g:\sqldata.|||Hi
This article descibes how to move your master database
http://support.microsoft.com/kb/224071/EN-US/
You may want to try starting SQL Server from the command prompt
http://msdn.microsoft.com/library/d...>
rvr_4apa.asp
with the correct parameters (possibly with -f also!) and also making sure
that the permissions for the directories being used are correct.
You can not use a mapped network drive for your database files.
John
"Ray Skweres" wrote:
> After changing the startup parameters and moving the database we are unabl
e
> to start SQL. The error message we are getting in the application log is
> that the initconfig: (error 5) access denied to g:\sqldata.|||Error 5 is access denied. Make sure that the SQL Server service account has
permissions to the file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ray Skweres" <RaySkweres@.discussions.microsoft.com> wrote in message
news:2053CEEC-32D3-4840-9898-D59433C29617@.microsoft.com...
> After changing the startup parameters and moving the database we are unabl
e
> to start SQL. The error message we are getting in the application log is
> that the initconfig: (error 5) access denied to g:\sqldata.|||Moved it based on Microsoft articel changed startup parameters and only move
d
the master.mdf so I only changed that parameter.
"doller" wrote:
> HI,
> How u moved the database and what parameter u have changed.
> from
> killer
>
> Ray Skweres wrote:
>|||Used this article to move the database also tried to start it from a command
prompt and would not start. Also tried to change the startup parameters bac
k
though command prompt and did not work. I am not using a mapped network
drive. Permissions are fine on the file. Even went into registry and tried
to change and then start sql still did not start and then when I went back
into the registry and it was back to the old setting.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> This article descibes how to move your master database
> http://support.microsoft.com/kb/224071/EN-US/
> You may want to try starting SQL Server from the command prompt
> http://msdn.microsoft.com/library/d...
servr_4apa.asp
> with the correct parameters (possibly with -f also!) and also making sure
> that the permissions for the directories being used are correct.
> You can not use a mapped network drive for your database files.
> John
> "Ray Skweres" wrote:
>|||Hi
Are you using the -d and -l parameters when starting on the command prompt?
Is there any privacy or anti-virus software running?
You may want to try reverting back to the previous location and see if it
starts.
If have backed up all your databases then you may want to try un-installing
and re-installing. You should be able to attach the databases from the
mdf/ldf files, but you will need to re-instate logins and jobs.
John
"Ray Skweres" wrote:
[vbcol=seagreen]
> Used this article to move the database also tried to start it from a comma
nd
> prompt and would not start. Also tried to change the startup parameters b
ack
> though command prompt and did not work. I am not using a mapped network
> drive. Permissions are fine on the file. Even went into registry and trie
d
> to change and then start sql still did not start and then when I went back
> into the registry and it was back to the old setting.
> "John Bell" wrote:
>|||Whether your the service account you are starting has access to the
g:\sqldata.
Thanks
Ajay Rengunthwar
MCDBA, MCAD
"Ray Skweres" <RaySkweres@.discussions.microsoft.com> wrote in message
news:19FD3DAA-35C5-482E-B0CD-FA8068B7FA71@.microsoft.com...
> Moved it based on Microsoft articel changed startup parameters and only
moved[vbcol=seagreen]
> the master.mdf so I only changed that parameter.
> "doller" wrote:
>
unable[vbcol=seagreen]
log is[vbcol=seagreen]|||Hi
Another thought, have you checked for disc corruption?
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:BFC7ACBD-19F4-4714-919B-C7774A17FFC7@.microsoft.com...[vbcol=seagreen]
> Hi
> Are you using the -d and -l parameters when starting on the command
> prompt?
> Is there any privacy or anti-virus software running?
> You may want to try reverting back to the previous location and see if it
> starts.
> If have backed up all your databases then you may want to try
> un-installing
> and re-installing. You should be able to attach the databases from the
> mdf/ldf files, but you will need to re-instate logins and jobs.
>
> John
> "Ray Skweres" wrote:
>
to start SQL. The error message we are getting in the application log is
that the initconfig: (error 5) access denied to g:\sqldata.HI,
How u moved the database and what parameter u have changed.
from
killer
Ray Skweres wrote:
> After changing the startup parameters and moving the database we are unabl
e
> to start SQL. The error message we are getting in the application log is
> that the initconfig: (error 5) access denied to g:\sqldata.|||Hi
This article descibes how to move your master database
http://support.microsoft.com/kb/224071/EN-US/
You may want to try starting SQL Server from the command prompt
http://msdn.microsoft.com/library/d...>
rvr_4apa.asp
with the correct parameters (possibly with -f also!) and also making sure
that the permissions for the directories being used are correct.
You can not use a mapped network drive for your database files.
John
"Ray Skweres" wrote:
> After changing the startup parameters and moving the database we are unabl
e
> to start SQL. The error message we are getting in the application log is
> that the initconfig: (error 5) access denied to g:\sqldata.|||Error 5 is access denied. Make sure that the SQL Server service account has
permissions to the file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ray Skweres" <RaySkweres@.discussions.microsoft.com> wrote in message
news:2053CEEC-32D3-4840-9898-D59433C29617@.microsoft.com...
> After changing the startup parameters and moving the database we are unabl
e
> to start SQL. The error message we are getting in the application log is
> that the initconfig: (error 5) access denied to g:\sqldata.|||Moved it based on Microsoft articel changed startup parameters and only move
d
the master.mdf so I only changed that parameter.
"doller" wrote:
> HI,
> How u moved the database and what parameter u have changed.
> from
> killer
>
> Ray Skweres wrote:
>|||Used this article to move the database also tried to start it from a command
prompt and would not start. Also tried to change the startup parameters bac
k
though command prompt and did not work. I am not using a mapped network
drive. Permissions are fine on the file. Even went into registry and tried
to change and then start sql still did not start and then when I went back
into the registry and it was back to the old setting.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> This article descibes how to move your master database
> http://support.microsoft.com/kb/224071/EN-US/
> You may want to try starting SQL Server from the command prompt
> http://msdn.microsoft.com/library/d...
servr_4apa.asp
> with the correct parameters (possibly with -f also!) and also making sure
> that the permissions for the directories being used are correct.
> You can not use a mapped network drive for your database files.
> John
> "Ray Skweres" wrote:
>|||Hi
Are you using the -d and -l parameters when starting on the command prompt?
Is there any privacy or anti-virus software running?
You may want to try reverting back to the previous location and see if it
starts.
If have backed up all your databases then you may want to try un-installing
and re-installing. You should be able to attach the databases from the
mdf/ldf files, but you will need to re-instate logins and jobs.
John
"Ray Skweres" wrote:
[vbcol=seagreen]
> Used this article to move the database also tried to start it from a comma
nd
> prompt and would not start. Also tried to change the startup parameters b
ack
> though command prompt and did not work. I am not using a mapped network
> drive. Permissions are fine on the file. Even went into registry and trie
d
> to change and then start sql still did not start and then when I went back
> into the registry and it was back to the old setting.
> "John Bell" wrote:
>|||Whether your the service account you are starting has access to the
g:\sqldata.
Thanks
Ajay Rengunthwar
MCDBA, MCAD
"Ray Skweres" <RaySkweres@.discussions.microsoft.com> wrote in message
news:19FD3DAA-35C5-482E-B0CD-FA8068B7FA71@.microsoft.com...
> Moved it based on Microsoft articel changed startup parameters and only
moved[vbcol=seagreen]
> the master.mdf so I only changed that parameter.
> "doller" wrote:
>
unable[vbcol=seagreen]
log is[vbcol=seagreen]|||Hi
Another thought, have you checked for disc corruption?
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:BFC7ACBD-19F4-4714-919B-C7774A17FFC7@.microsoft.com...[vbcol=seagreen]
> Hi
> Are you using the -d and -l parameters when starting on the command
> prompt?
> Is there any privacy or anti-virus software running?
> You may want to try reverting back to the previous location and see if it
> starts.
> If have backed up all your databases then you may want to try
> un-installing
> and re-installing. You should be able to attach the databases from the
> mdf/ldf files, but you will need to re-instate logins and jobs.
>
> John
> "Ray Skweres" wrote:
>
Moved master db and now cannot start SQL
After changing the startup parameters and moving the database we are unable
to start SQL. The error message we are getting in the application log is
that the initconfig: (error 5) access denied to g:\sqldata.HI,
How u moved the database and what parameter u have changed.
from
killer
Ray Skweres wrote:
> After changing the startup parameters and moving the database we are unable
> to start SQL. The error message we are getting in the application log is
> that the initconfig: (error 5) access denied to g:\sqldata.|||Hi
This article descibes how to move your master database
http://support.microsoft.com/kb/224071/EN-US/
You may want to try starting SQL Server from the command prompt
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_sqlservr_4apa.asp
with the correct parameters (possibly with -f also!) and also making sure
that the permissions for the directories being used are correct.
You can not use a mapped network drive for your database files.
John
"Ray Skweres" wrote:
> After changing the startup parameters and moving the database we are unable
> to start SQL. The error message we are getting in the application log is
> that the initconfig: (error 5) access denied to g:\sqldata.|||Error 5 is access denied. Make sure that the SQL Server service account has permissions to the file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ray Skweres" <RaySkweres@.discussions.microsoft.com> wrote in message
news:2053CEEC-32D3-4840-9898-D59433C29617@.microsoft.com...
> After changing the startup parameters and moving the database we are unable
> to start SQL. The error message we are getting in the application log is
> that the initconfig: (error 5) access denied to g:\sqldata.|||Moved it based on Microsoft articel changed startup parameters and only moved
the master.mdf so I only changed that parameter.
"doller" wrote:
> HI,
> How u moved the database and what parameter u have changed.
> from
> killer
>
> Ray Skweres wrote:
> > After changing the startup parameters and moving the database we are unable
> > to start SQL. The error message we are getting in the application log is
> > that the initconfig: (error 5) access denied to g:\sqldata.
>|||Used this article to move the database also tried to start it from a command
prompt and would not start. Also tried to change the startup parameters back
though command prompt and did not work. I am not using a mapped network
drive. Permissions are fine on the file. Even went into registry and tried
to change and then start sql still did not start and then when I went back
into the registry and it was back to the old setting.
"John Bell" wrote:
> Hi
> This article descibes how to move your master database
> http://support.microsoft.com/kb/224071/EN-US/
> You may want to try starting SQL Server from the command prompt
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_sqlservr_4apa.asp
> with the correct parameters (possibly with -f also!) and also making sure
> that the permissions for the directories being used are correct.
> You can not use a mapped network drive for your database files.
> John
> "Ray Skweres" wrote:
> > After changing the startup parameters and moving the database we are unable
> > to start SQL. The error message we are getting in the application log is
> > that the initconfig: (error 5) access denied to g:\sqldata.|||Hi
Are you using the -d and -l parameters when starting on the command prompt?
Is there any privacy or anti-virus software running?
You may want to try reverting back to the previous location and see if it
starts.
If have backed up all your databases then you may want to try un-installing
and re-installing. You should be able to attach the databases from the
mdf/ldf files, but you will need to re-instate logins and jobs.
John
"Ray Skweres" wrote:
> Used this article to move the database also tried to start it from a command
> prompt and would not start. Also tried to change the startup parameters back
> though command prompt and did not work. I am not using a mapped network
> drive. Permissions are fine on the file. Even went into registry and tried
> to change and then start sql still did not start and then when I went back
> into the registry and it was back to the old setting.
> "John Bell" wrote:
> > Hi
> >
> > This article descibes how to move your master database
> > http://support.microsoft.com/kb/224071/EN-US/
> >
> > You may want to try starting SQL Server from the command prompt
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_sqlservr_4apa.asp
> > with the correct parameters (possibly with -f also!) and also making sure
> > that the permissions for the directories being used are correct.
> >
> > You can not use a mapped network drive for your database files.
> >
> > John
> >
> > "Ray Skweres" wrote:
> >
> > > After changing the startup parameters and moving the database we are unable
> > > to start SQL. The error message we are getting in the application log is
> > > that the initconfig: (error 5) access denied to g:\sqldata.|||Whether your the service account you are starting has access to the
g:\sqldata.
Thanks
Ajay Rengunthwar
MCDBA, MCAD
"Ray Skweres" <RaySkweres@.discussions.microsoft.com> wrote in message
news:19FD3DAA-35C5-482E-B0CD-FA8068B7FA71@.microsoft.com...
> Moved it based on Microsoft articel changed startup parameters and only
moved
> the master.mdf so I only changed that parameter.
> "doller" wrote:
> > HI,
> > How u moved the database and what parameter u have changed.
> >
> > from
> > killer
> >
> >
> > Ray Skweres wrote:
> > > After changing the startup parameters and moving the database we are
unable
> > > to start SQL. The error message we are getting in the application
log is
> > > that the initconfig: (error 5) access denied to g:\sqldata.
> >
> >|||Hi
Another thought, have you checked for disc corruption?
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:BFC7ACBD-19F4-4714-919B-C7774A17FFC7@.microsoft.com...
> Hi
> Are you using the -d and -l parameters when starting on the command
> prompt?
> Is there any privacy or anti-virus software running?
> You may want to try reverting back to the previous location and see if it
> starts.
> If have backed up all your databases then you may want to try
> un-installing
> and re-installing. You should be able to attach the databases from the
> mdf/ldf files, but you will need to re-instate logins and jobs.
>
> John
> "Ray Skweres" wrote:
>> Used this article to move the database also tried to start it from a
>> command
>> prompt and would not start. Also tried to change the startup parameters
>> back
>> though command prompt and did not work. I am not using a mapped network
>> drive. Permissions are fine on the file. Even went into registry and
>> tried
>> to change and then start sql still did not start and then when I went
>> back
>> into the registry and it was back to the old setting.
>> "John Bell" wrote:
>> > Hi
>> >
>> > This article descibes how to move your master database
>> > http://support.microsoft.com/kb/224071/EN-US/
>> >
>> > You may want to try starting SQL Server from the command prompt
>> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_sqlservr_4apa.asp
>> > with the correct parameters (possibly with -f also!) and also making
>> > sure
>> > that the permissions for the directories being used are correct.
>> >
>> > You can not use a mapped network drive for your database files.
>> >
>> > John
>> >
>> > "Ray Skweres" wrote:
>> >
>> > > After changing the startup parameters and moving the database we are
>> > > unable
>> > > to start SQL. The error message we are getting in the application
>> > > log is
>> > > that the initconfig: (error 5) access denied to g:\sqldata.
to start SQL. The error message we are getting in the application log is
that the initconfig: (error 5) access denied to g:\sqldata.HI,
How u moved the database and what parameter u have changed.
from
killer
Ray Skweres wrote:
> After changing the startup parameters and moving the database we are unable
> to start SQL. The error message we are getting in the application log is
> that the initconfig: (error 5) access denied to g:\sqldata.|||Hi
This article descibes how to move your master database
http://support.microsoft.com/kb/224071/EN-US/
You may want to try starting SQL Server from the command prompt
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_sqlservr_4apa.asp
with the correct parameters (possibly with -f also!) and also making sure
that the permissions for the directories being used are correct.
You can not use a mapped network drive for your database files.
John
"Ray Skweres" wrote:
> After changing the startup parameters and moving the database we are unable
> to start SQL. The error message we are getting in the application log is
> that the initconfig: (error 5) access denied to g:\sqldata.|||Error 5 is access denied. Make sure that the SQL Server service account has permissions to the file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ray Skweres" <RaySkweres@.discussions.microsoft.com> wrote in message
news:2053CEEC-32D3-4840-9898-D59433C29617@.microsoft.com...
> After changing the startup parameters and moving the database we are unable
> to start SQL. The error message we are getting in the application log is
> that the initconfig: (error 5) access denied to g:\sqldata.|||Moved it based on Microsoft articel changed startup parameters and only moved
the master.mdf so I only changed that parameter.
"doller" wrote:
> HI,
> How u moved the database and what parameter u have changed.
> from
> killer
>
> Ray Skweres wrote:
> > After changing the startup parameters and moving the database we are unable
> > to start SQL. The error message we are getting in the application log is
> > that the initconfig: (error 5) access denied to g:\sqldata.
>|||Used this article to move the database also tried to start it from a command
prompt and would not start. Also tried to change the startup parameters back
though command prompt and did not work. I am not using a mapped network
drive. Permissions are fine on the file. Even went into registry and tried
to change and then start sql still did not start and then when I went back
into the registry and it was back to the old setting.
"John Bell" wrote:
> Hi
> This article descibes how to move your master database
> http://support.microsoft.com/kb/224071/EN-US/
> You may want to try starting SQL Server from the command prompt
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_sqlservr_4apa.asp
> with the correct parameters (possibly with -f also!) and also making sure
> that the permissions for the directories being used are correct.
> You can not use a mapped network drive for your database files.
> John
> "Ray Skweres" wrote:
> > After changing the startup parameters and moving the database we are unable
> > to start SQL. The error message we are getting in the application log is
> > that the initconfig: (error 5) access denied to g:\sqldata.|||Hi
Are you using the -d and -l parameters when starting on the command prompt?
Is there any privacy or anti-virus software running?
You may want to try reverting back to the previous location and see if it
starts.
If have backed up all your databases then you may want to try un-installing
and re-installing. You should be able to attach the databases from the
mdf/ldf files, but you will need to re-instate logins and jobs.
John
"Ray Skweres" wrote:
> Used this article to move the database also tried to start it from a command
> prompt and would not start. Also tried to change the startup parameters back
> though command prompt and did not work. I am not using a mapped network
> drive. Permissions are fine on the file. Even went into registry and tried
> to change and then start sql still did not start and then when I went back
> into the registry and it was back to the old setting.
> "John Bell" wrote:
> > Hi
> >
> > This article descibes how to move your master database
> > http://support.microsoft.com/kb/224071/EN-US/
> >
> > You may want to try starting SQL Server from the command prompt
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_sqlservr_4apa.asp
> > with the correct parameters (possibly with -f also!) and also making sure
> > that the permissions for the directories being used are correct.
> >
> > You can not use a mapped network drive for your database files.
> >
> > John
> >
> > "Ray Skweres" wrote:
> >
> > > After changing the startup parameters and moving the database we are unable
> > > to start SQL. The error message we are getting in the application log is
> > > that the initconfig: (error 5) access denied to g:\sqldata.|||Whether your the service account you are starting has access to the
g:\sqldata.
Thanks
Ajay Rengunthwar
MCDBA, MCAD
"Ray Skweres" <RaySkweres@.discussions.microsoft.com> wrote in message
news:19FD3DAA-35C5-482E-B0CD-FA8068B7FA71@.microsoft.com...
> Moved it based on Microsoft articel changed startup parameters and only
moved
> the master.mdf so I only changed that parameter.
> "doller" wrote:
> > HI,
> > How u moved the database and what parameter u have changed.
> >
> > from
> > killer
> >
> >
> > Ray Skweres wrote:
> > > After changing the startup parameters and moving the database we are
unable
> > > to start SQL. The error message we are getting in the application
log is
> > > that the initconfig: (error 5) access denied to g:\sqldata.
> >
> >|||Hi
Another thought, have you checked for disc corruption?
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:BFC7ACBD-19F4-4714-919B-C7774A17FFC7@.microsoft.com...
> Hi
> Are you using the -d and -l parameters when starting on the command
> prompt?
> Is there any privacy or anti-virus software running?
> You may want to try reverting back to the previous location and see if it
> starts.
> If have backed up all your databases then you may want to try
> un-installing
> and re-installing. You should be able to attach the databases from the
> mdf/ldf files, but you will need to re-instate logins and jobs.
>
> John
> "Ray Skweres" wrote:
>> Used this article to move the database also tried to start it from a
>> command
>> prompt and would not start. Also tried to change the startup parameters
>> back
>> though command prompt and did not work. I am not using a mapped network
>> drive. Permissions are fine on the file. Even went into registry and
>> tried
>> to change and then start sql still did not start and then when I went
>> back
>> into the registry and it was back to the old setting.
>> "John Bell" wrote:
>> > Hi
>> >
>> > This article descibes how to move your master database
>> > http://support.microsoft.com/kb/224071/EN-US/
>> >
>> > You may want to try starting SQL Server from the command prompt
>> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_sqlservr_4apa.asp
>> > with the correct parameters (possibly with -f also!) and also making
>> > sure
>> > that the permissions for the directories being used are correct.
>> >
>> > You can not use a mapped network drive for your database files.
>> >
>> > John
>> >
>> > "Ray Skweres" wrote:
>> >
>> > > After changing the startup parameters and moving the database we are
>> > > unable
>> > > to start SQL. The error message we are getting in the application
>> > > log is
>> > > that the initconfig: (error 5) access denied to g:\sqldata.
Monday, March 19, 2012
Move SQL Server Management Studio Startup folder
Hello,
I recently moved the two following folders (SQL Server Management Studio,
Visual Studio 2005) to another directory but got the following error:
...Import and Export Settings tools Options page. The IDE will use your
most recent setting for this session
When I opened Enterprise Manager, it recreated the folders. I went to
Tools/Options, but couldn't find the option to change the start up location.
Any assistance with this would be appreciated.
--
Thanks in advance,
sck10Hi sck,
Thanks for using MSDN Managed Newsgroup Support.
By default, the SQL Management Studio is located at %Program Files
%\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe. If you
moved the SQL Management Studio, please go to the folder and find the
SqlWb.exe application. What's the result? Do you get any error message?
Please provide the entire error so that we may do the further troubleshoot.
Basically, we do not recommand move the SQL Management Studio folder and
the Visual Studio 2005 folder directly. This may cause some application
could not found the referenced files. The best way to move these folder is
re-install the Visual Studio and the SQL Management Studio.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei Lu,
I am referencing the folders that SS2K5 makes in the "My Documents" and
where can I change the pointer to another directory.
C:\Documents and Settings\sck10\My Documents\SQL Server Management Studio
Backup
Code Snippets
Projects
Settings
Templates
Thanks,
sck10
"Wei Lu" <weilu@.online.microsoft.com> wrote in message
news:nSxQTvBaGHA.880@.TK2MSFTNGXA01.phx.gbl...
> Hi sck,
> Thanks for using MSDN Managed Newsgroup Support.
> By default, the SQL Management Studio is located at %Program Files
> %\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe. If you
> moved the SQL Management Studio, please go to the folder and find the
> SqlWb.exe application. What's the result? Do you get any error message?
> Please provide the entire error so that we may do the further
troubleshoot.
> Basically, we do not recommand move the SQL Management Studio folder and
> the Visual Studio 2005 folder directly. This may cause some application
> could not found the referenced files. The best way to move these folder is
> re-install the Visual Studio and the SQL Management Studio.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
rights.
>|||Hi sck10,
Thanks for the update.
My understanding of your issue is: You want to specify the location when
you create a project/ solution in SQL Management Studio. If I misunderstood
your concern, please feel free to let me know.
You could change the location where your Project store in the location
textbox. Also you can Browse to the location you want to store the project.
By default, SQL Management Studio will create the project in the My
Documents\SQL Server Management Studio\Projects folder.
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>References: <#fQKPj6ZGHA.4116@.TK2MSFTNGP05.phx.gbl>
<nSxQTvBaGHA.880@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Move SQL Server Management Studio Startup folder
>Date: Wed, 26 Apr 2006 08:52:15 -0500
>Lines: 49
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807
>Message-ID: <eGEohiTaGHA.1240@.TK2MSFTNGP03.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:429301
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hi Wei Lu,
>I am referencing the folders that SS2K5 makes in the "My Documents" and
>where can I change the pointer to another directory.
>C:\Documents and Settings\sck10\My Documents\SQL Server Management Studio
>Backup
>Code Snippets
>Projects
>Settings
>Templates
>Thanks,
>sck10
>"Wei Lu" <weilu@.online.microsoft.com> wrote in message
>news:nSxQTvBaGHA.880@.TK2MSFTNGXA01.phx.gbl...
>> Hi sck,
>> Thanks for using MSDN Managed Newsgroup Support.
>> By default, the SQL Management Studio is located at %Program Files
>> %\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe. If
you
>> moved the SQL Management Studio, please go to the folder and find the
>> SqlWb.exe application. What's the result? Do you get any error message?
>> Please provide the entire error so that we may do the further
>troubleshoot.
>> Basically, we do not recommand move the SQL Management Studio folder and
>> the Visual Studio 2005 folder directly. This may cause some application
>> could not found the referenced files. The best way to move these folder
is
>> re-install the Visual Studio and the SQL Management Studio.
>> Sincerely,
>> Wei Lu
>> Microsoft Online Community Support
>> ==================================================>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> ==================================================>> This posting is provided "AS IS" with no warranties, and confers no
>rights.
>
>|||I have the same problem. Allow me to restate the issue from my point of
view, and maybe someone has an answer:
When I am in Management Studio and choose File... Open... File, the
standard Open File dialog box lists 3 icons in the left side: Desktop, My
Projects, and My Computer. The My Projects folder points to My Documents/SQL
Server Management Studio/My Projects.
I understand that this is the default location. I would like to CHANGE the
default location to a different folder.
There doesn't seem to be an option to set this default location in the
Management Studio Options. I tried to find the reference in the registry,
but cannot.
Alternatively, I would be happy to be able to ADD my preferred folder to
this dialog
I recently moved the two following folders (SQL Server Management Studio,
Visual Studio 2005) to another directory but got the following error:
...Import and Export Settings tools Options page. The IDE will use your
most recent setting for this session
When I opened Enterprise Manager, it recreated the folders. I went to
Tools/Options, but couldn't find the option to change the start up location.
Any assistance with this would be appreciated.
--
Thanks in advance,
sck10Hi sck,
Thanks for using MSDN Managed Newsgroup Support.
By default, the SQL Management Studio is located at %Program Files
%\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe. If you
moved the SQL Management Studio, please go to the folder and find the
SqlWb.exe application. What's the result? Do you get any error message?
Please provide the entire error so that we may do the further troubleshoot.
Basically, we do not recommand move the SQL Management Studio folder and
the Visual Studio 2005 folder directly. This may cause some application
could not found the referenced files. The best way to move these folder is
re-install the Visual Studio and the SQL Management Studio.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei Lu,
I am referencing the folders that SS2K5 makes in the "My Documents" and
where can I change the pointer to another directory.
C:\Documents and Settings\sck10\My Documents\SQL Server Management Studio
Backup
Code Snippets
Projects
Settings
Templates
Thanks,
sck10
"Wei Lu" <weilu@.online.microsoft.com> wrote in message
news:nSxQTvBaGHA.880@.TK2MSFTNGXA01.phx.gbl...
> Hi sck,
> Thanks for using MSDN Managed Newsgroup Support.
> By default, the SQL Management Studio is located at %Program Files
> %\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe. If you
> moved the SQL Management Studio, please go to the folder and find the
> SqlWb.exe application. What's the result? Do you get any error message?
> Please provide the entire error so that we may do the further
troubleshoot.
> Basically, we do not recommand move the SQL Management Studio folder and
> the Visual Studio 2005 folder directly. This may cause some application
> could not found the referenced files. The best way to move these folder is
> re-install the Visual Studio and the SQL Management Studio.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
rights.
>|||Hi sck10,
Thanks for the update.
My understanding of your issue is: You want to specify the location when
you create a project/ solution in SQL Management Studio. If I misunderstood
your concern, please feel free to let me know.
You could change the location where your Project store in the location
textbox. Also you can Browse to the location you want to store the project.
By default, SQL Management Studio will create the project in the My
Documents\SQL Server Management Studio\Projects folder.
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>References: <#fQKPj6ZGHA.4116@.TK2MSFTNGP05.phx.gbl>
<nSxQTvBaGHA.880@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Move SQL Server Management Studio Startup folder
>Date: Wed, 26 Apr 2006 08:52:15 -0500
>Lines: 49
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807
>Message-ID: <eGEohiTaGHA.1240@.TK2MSFTNGP03.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:429301
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hi Wei Lu,
>I am referencing the folders that SS2K5 makes in the "My Documents" and
>where can I change the pointer to another directory.
>C:\Documents and Settings\sck10\My Documents\SQL Server Management Studio
>Backup
>Code Snippets
>Projects
>Settings
>Templates
>Thanks,
>sck10
>"Wei Lu" <weilu@.online.microsoft.com> wrote in message
>news:nSxQTvBaGHA.880@.TK2MSFTNGXA01.phx.gbl...
>> Hi sck,
>> Thanks for using MSDN Managed Newsgroup Support.
>> By default, the SQL Management Studio is located at %Program Files
>> %\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe. If
you
>> moved the SQL Management Studio, please go to the folder and find the
>> SqlWb.exe application. What's the result? Do you get any error message?
>> Please provide the entire error so that we may do the further
>troubleshoot.
>> Basically, we do not recommand move the SQL Management Studio folder and
>> the Visual Studio 2005 folder directly. This may cause some application
>> could not found the referenced files. The best way to move these folder
is
>> re-install the Visual Studio and the SQL Management Studio.
>> Sincerely,
>> Wei Lu
>> Microsoft Online Community Support
>> ==================================================>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> ==================================================>> This posting is provided "AS IS" with no warranties, and confers no
>rights.
>
>|||I have the same problem. Allow me to restate the issue from my point of
view, and maybe someone has an answer:
When I am in Management Studio and choose File... Open... File, the
standard Open File dialog box lists 3 icons in the left side: Desktop, My
Projects, and My Computer. The My Projects folder points to My Documents/SQL
Server Management Studio/My Projects.
I understand that this is the default location. I would like to CHANGE the
default location to a different folder.
There doesn't seem to be an option to set this default location in the
Management Studio Options. I tried to find the reference in the registry,
but cannot.
Alternatively, I would be happy to be able to ADD my preferred folder to
this dialog
Move SQL Server Management Studio Startup folder
Hello,
I recently moved the two following folders (SQL Server Management Studio,
Visual Studio 2005) to another directory but got the following error:
..Import and Export Settings tools Options page. The IDE will use your
most recent setting for this session
When I opened Enterprise Manager, it recreated the folders. I went to
Tools/Options, but couldn't find the option to change the start up location.
Any assistance with this would be appreciated.
--
Thanks in advance,
sck10Hi sck,
Thanks for using MSDN Managed Newsgroup Support.
By default, the SQL Management Studio is located at %Program Files
%\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE
\SqlWb.exe. If you
moved the SQL Management Studio, please go to the folder and find the
SqlWb.exe application. What's the result? Do you get any error message?
Please provide the entire error so that we may do the further troubleshoot.
Basically, we do not recommand move the SQL Management Studio folder and
the Visual Studio 2005 folder directly. This may cause some application
could not found the referenced files. The best way to move these folder is
re-install the Visual Studio and the SQL Management Studio.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei Lu,
I am referencing the folders that SS2K5 makes in the "My Documents" and
where can I change the pointer to another directory.
C:\Documents and Settings\sck10\My Documents\SQL Server Management Studio
Backup
Code Snippets
Projects
Settings
Templates
Thanks,
sck10
"Wei Lu" <weilu@.online.microsoft.com> wrote in message
news:nSxQTvBaGHA.880@.TK2MSFTNGXA01.phx.gbl...
> Hi sck,
> Thanks for using MSDN Managed Newsgroup Support.
> By default, the SQL Management Studio is located at %Program Files
> %\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE
\SqlWb.exe. If you
> moved the SQL Management Studio, please go to the folder and find the
> SqlWb.exe application. What's the result? Do you get any error message?
> Please provide the entire error so that we may do the further
troubleshoot.
> Basically, we do not recommand move the SQL Management Studio folder and
> the Visual Studio 2005 folder directly. This may cause some application
> could not found the referenced files. The best way to move these folder is
> re-install the Visual Studio and the SQL Management Studio.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ========================================
==========
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>|||Hi sck10,
Thanks for the update.
My understanding of your issue is: You want to specify the location when
you create a project/ solution in SQL Management Studio. If I misunderstood
your concern, please feel free to let me know.
You could change the location where your Project store in the location
textbox. Also you can Browse to the location you want to store the project.
By default, SQL Management Studio will create the project in the My
Documents\SQL Server Management Studio\Projects folder.
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>References: <#fQKPj6ZGHA.4116@.TK2MSFTNGP05.phx.gbl>
<nSxQTvBaGHA.880@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Move SQL Server Management Studio Startup folder
>Date: Wed, 26 Apr 2006 08:52:15 -0500
>Lines: 49
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807
>Message-ID: <eGEohiTaGHA.1240@.TK2MSFTNGP03.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:429301
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hi Wei Lu,
>I am referencing the folders that SS2K5 makes in the "My Documents" and
>where can I change the pointer to another directory.
>C:\Documents and Settings\sck10\My Documents\SQL Server Management Studio
>Backup
>Code Snippets
>Projects
>Settings
>Templates
>Thanks,
>sck10
>"Wei Lu" <weilu@.online.microsoft.com> wrote in message
>news:nSxQTvBaGHA.880@.TK2MSFTNGXA01.phx.gbl...
you[vbcol=seagreen]
>troubleshoot.
is[vbcol=seagreen]
>rights.
>
>|||I have the same problem. Allow me to restate the issue from my point of
view, and maybe someone has an answer:
When I am in Management Studio and choose File... Open... File, the
standard Open File dialog box lists 3 icons in the left side: Desktop, My
Projects, and My Computer. The My Projects folder points to My Documents/SQ
L
Server Management Studio/My Projects.
I understand that this is the default location. I would like to CHANGE the
default location to a different folder.
There doesn't seem to be an option to set this default location in the
Management Studio Options. I tried to find the reference in the registry,
but cannot.
Alternatively, I would be happy to be able to ADD my preferred folder to
this dialog
I recently moved the two following folders (SQL Server Management Studio,
Visual Studio 2005) to another directory but got the following error:
..Import and Export Settings tools Options page. The IDE will use your
most recent setting for this session
When I opened Enterprise Manager, it recreated the folders. I went to
Tools/Options, but couldn't find the option to change the start up location.
Any assistance with this would be appreciated.
--
Thanks in advance,
sck10Hi sck,
Thanks for using MSDN Managed Newsgroup Support.
By default, the SQL Management Studio is located at %Program Files
%\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE
\SqlWb.exe. If you
moved the SQL Management Studio, please go to the folder and find the
SqlWb.exe application. What's the result? Do you get any error message?
Please provide the entire error so that we may do the further troubleshoot.
Basically, we do not recommand move the SQL Management Studio folder and
the Visual Studio 2005 folder directly. This may cause some application
could not found the referenced files. The best way to move these folder is
re-install the Visual Studio and the SQL Management Studio.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei Lu,
I am referencing the folders that SS2K5 makes in the "My Documents" and
where can I change the pointer to another directory.
C:\Documents and Settings\sck10\My Documents\SQL Server Management Studio
Backup
Code Snippets
Projects
Settings
Templates
Thanks,
sck10
"Wei Lu" <weilu@.online.microsoft.com> wrote in message
news:nSxQTvBaGHA.880@.TK2MSFTNGXA01.phx.gbl...
> Hi sck,
> Thanks for using MSDN Managed Newsgroup Support.
> By default, the SQL Management Studio is located at %Program Files
> %\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE
\SqlWb.exe. If you
> moved the SQL Management Studio, please go to the folder and find the
> SqlWb.exe application. What's the result? Do you get any error message?
> Please provide the entire error so that we may do the further
troubleshoot.
> Basically, we do not recommand move the SQL Management Studio folder and
> the Visual Studio 2005 folder directly. This may cause some application
> could not found the referenced files. The best way to move these folder is
> re-install the Visual Studio and the SQL Management Studio.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ========================================
==========
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>|||Hi sck10,
Thanks for the update.
My understanding of your issue is: You want to specify the location when
you create a project/ solution in SQL Management Studio. If I misunderstood
your concern, please feel free to let me know.
You could change the location where your Project store in the location
textbox. Also you can Browse to the location you want to store the project.
By default, SQL Management Studio will create the project in the My
Documents\SQL Server Management Studio\Projects folder.
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>References: <#fQKPj6ZGHA.4116@.TK2MSFTNGP05.phx.gbl>
<nSxQTvBaGHA.880@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Move SQL Server Management Studio Startup folder
>Date: Wed, 26 Apr 2006 08:52:15 -0500
>Lines: 49
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807
>Message-ID: <eGEohiTaGHA.1240@.TK2MSFTNGP03.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:429301
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hi Wei Lu,
>I am referencing the folders that SS2K5 makes in the "My Documents" and
>where can I change the pointer to another directory.
>C:\Documents and Settings\sck10\My Documents\SQL Server Management Studio
>Backup
>Code Snippets
>Projects
>Settings
>Templates
>Thanks,
>sck10
>"Wei Lu" <weilu@.online.microsoft.com> wrote in message
>news:nSxQTvBaGHA.880@.TK2MSFTNGXA01.phx.gbl...
you[vbcol=seagreen]
>troubleshoot.
is[vbcol=seagreen]
>rights.
>
>|||I have the same problem. Allow me to restate the issue from my point of
view, and maybe someone has an answer:
When I am in Management Studio and choose File... Open... File, the
standard Open File dialog box lists 3 icons in the left side: Desktop, My
Projects, and My Computer. The My Projects folder points to My Documents/SQ
L
Server Management Studio/My Projects.
I understand that this is the default location. I would like to CHANGE the
default location to a different folder.
There doesn't seem to be an option to set this default location in the
Management Studio Options. I tried to find the reference in the registry,
but cannot.
Alternatively, I would be happy to be able to ADD my preferred folder to
this dialog
Subscribe to:
Posts (Atom)