Path to configuration files

Can someone tell me why path to the configuration file couldn't be relative to the package? When I try to use relative path (i.e. do not specify full path to the configuration file) package then run from BIDS looks for configuration file in the solution folder instead of package's folder (project folder).

Is there ane way to force package use same folder to search for caonfiguration files?

Thanks

No unfortunately not. Maybe this is something you could request at http://connect.microsoft.com/sqlserver/feedback

I don't know the rationale for not allowing relative paths but I would guess its because how would you know what the path relative to a package is if the package is stored in SQL Server? If you look at it from this perspective absolute paths make more sense.

-Jamie

|||

Ok. I'll try to live with it now=/

It seems very srange to me why no one at MSFT even think about of deployment process of ETL solutions to end-user's environment

|||

So, by the way, may be you know where package will search for configuration files if package stored in "program files\my company\my solution" folder and exeuted by dtexec in the way like this:

dtexec /file:"program files\my company\my solution\mypackage.dtsx"?

|||

Andrey Makarov wrote:

Ok. I'll try to live with it now=/

It seems very srange to me why no one at MSFT even think about of deployment process of ETL solutions to end-user's environment

Well, they did think about it. They just got it wrong that's all :) That is to say, there is a bug.

-Jamie

|||

Andrey Makarov wrote:

So, by the way, may be you know where package will search for configuration files if package stored in "program files\my company\my solution" folder and exeuted by dtexec in the way like this:

dtexec /file:"program files\my company\my solution\mypackage.dtsx"?

No. Perhaps you can tell me?

-Jamie

Passwords in the SSIS configuration file

Thanks to some earlier help from this forum, I have my package running using configuration files and Windows Authentication. However, when I try to execute the package using Sql authentication, login fails for the user i am specifying. When I check out the configuration file, the connection string does not contain the password. I added the password to the connection string, but it does not cone back. I followed the instructions found on the following site:

http://www.nigelrivett.net/DTS/SSISConfigurationFile.html

After trying what was suggested there, I was still unsuccessful with my login attempt.

Anyone know how to set up a package to run using Sql authentication?

Thanks!

Craig

At the time of development, set the protection level of package to EncryptSensitiveWithUserKey, after this sertting the package will store the sensitive information like password in itself.

Atul

Password Encryption in XML File

I am unable to encrypt password of sqlserver database in XML file by Package Configuration in SSIS.

I think that is not possible (though it might be possible if you develop something). According to the SSIS help you can either save the config file in SQL Server or use Windows access control lists to protect access to your config file. See ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.de/extran9/html/2e3ddea9-5289-4289-a70e-11c018f34977.htm|||Yes in config file i have to put the password manually in config file.If i choose only connection string property in configuration wizard then it is working fine.But When i reset the server password then it fails.So i have to give the password.But unable to encrypt it for security reasons.

password case seasitive configuration

Hi, All,
I just upgrade sql 2000 to sql 2005, and try to run asp webpage to access
sql 2005 data, but the password is case seasitive. The sql 2000 is not case
seasitive, anyone knows we can configure sql 2005 user password is not
seasitive?
Thanks for your time,
MartinTo the best of my knowledge, you cannot change to case insensitive passwords in 2005. This behavior
change is documented in:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"martin1" <martin1@.discussions.microsoft.com> wrote in message
news:6108FE0B-D229-4E56-9CC9-9483AA210FC6@.microsoft.com...
> Hi, All,
> I just upgrade sql 2000 to sql 2005, and try to run asp webpage to access
> sql 2005 data, but the password is case seasitive. The sql 2000 is not case
> seasitive, anyone knows we can configure sql 2005 user password is not
> seasitive?
> Thanks for your time,
> Martin|||Hi, Tibor Karaszi,
1) if not in Sql 2005, do you know we can configute IIS web server is not
case seasitive?
2) where to see
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm ? can you tell how to go there.
Thanks in advance,
Martin
"Tibor Karaszi" wrote:
> To the best of my knowledge, you cannot change to case insensitive passwords in 2005. This behavior
> change is documented in:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> news:6108FE0B-D229-4E56-9CC9-9483AA210FC6@.microsoft.com...
> > Hi, All,
> >
> > I just upgrade sql 2000 to sql 2005, and try to run asp webpage to access
> > sql 2005 data, but the password is case seasitive. The sql 2000 is not case
> > seasitive, anyone knows we can configure sql 2005 user password is not
> > seasitive?
> >
> > Thanks for your time,
> > Martin
>|||1: SQL Server 2000 and earlier: Whether a password is case sensitive or not is determined by the
collation for the system databases (AFAIK), which was decided when you installed the SQL Server
instances. To change this, you need to use rebuildm.exe which will scratch all the system databases,
and should be performed unless you have good knowledge of the SQL Server architecture and can
determine what such a rebuild will do.
2: This is an URL for the Books Online that comes with SQL Server 2005. It is installed when you
install 2005, and you find an like in the SQL Server program group.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"martin1" <martin1@.discussions.microsoft.com> wrote in message
news:059E056C-0F3A-4DCE-AADA-9EDE468DAAE6@.microsoft.com...
> Hi, Tibor Karaszi,
> 1) if not in Sql 2005, do you know we can configute IIS web server is not
> case seasitive?
> 2) where to see
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm ? can
> you tell how to go there.
> Thanks in advance,
> Martin
>
> "Tibor Karaszi" wrote:
>> To the best of my knowledge, you cannot change to case insensitive passwords in 2005. This
>> behavior
>> change is documented in:
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "martin1" <martin1@.discussions.microsoft.com> wrote in message
>> news:6108FE0B-D229-4E56-9CC9-9483AA210FC6@.microsoft.com...
>> > Hi, All,
>> >
>> > I just upgrade sql 2000 to sql 2005, and try to run asp webpage to access
>> > sql 2005 data, but the password is case seasitive. The sql 2000 is not case
>> > seasitive, anyone knows we can configure sql 2005 user password is not
>> > seasitive?
>> >
>> > Thanks for your time,
>> > Martin
>>|||Hi, Tibor Karaszi,
yuo mean sql server case seasitive can be changed by rebuidm.exe, this is
for sql 2000 or sql 2005?
Thanks
"Tibor Karaszi" wrote:
> 1: SQL Server 2000 and earlier: Whether a password is case sensitive or not is determined by the
> collation for the system databases (AFAIK), which was decided when you installed the SQL Server
> instances. To change this, you need to use rebuildm.exe which will scratch all the system databases,
> and should be performed unless you have good knowledge of the SQL Server architecture and can
> determine what such a rebuild will do.
> 2: This is an URL for the Books Online that comes with SQL Server 2005. It is installed when you
> install 2005, and you find an like in the SQL Server program group.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> news:059E056C-0F3A-4DCE-AADA-9EDE468DAAE6@.microsoft.com...
> > Hi, Tibor Karaszi,
> >
> > 1) if not in Sql 2005, do you know we can configute IIS web server is not
> > case seasitive?
> > 2) where to see
> > ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm ? can
> > you tell how to go there.
> >
> > Thanks in advance,
> > Martin
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> To the best of my knowledge, you cannot change to case insensitive passwords in 2005. This
> >> behavior
> >> change is documented in:
> >> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> >> news:6108FE0B-D229-4E56-9CC9-9483AA210FC6@.microsoft.com...
> >> > Hi, All,
> >> >
> >> > I just upgrade sql 2000 to sql 2005, and try to run asp webpage to access
> >> > sql 2005 data, but the password is case seasitive. The sql 2000 is not case
> >> > seasitive, anyone knows we can configure sql 2005 user password is not
> >> > seasitive?
> >> >
> >> > Thanks for your time,
> >> > Martin
> >>
> >>
>|||That only applies to 2000, logins are *always* case sensitive in 2005.
If you want to try this (2000): Make sure you test this on a test server first, as I'm not 100%
positive. But be aware that rebuildm does *a lot* of other things as well (it is pretty close to a
re-install). This is why I mentioned that you should be very familiar with what rebuildm does and
the consequences to running it, etc, before attempting this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"martin1" <martin1@.discussions.microsoft.com> wrote in message
news:BF694D38-6032-4598-9CB6-4042F7D6BFC0@.microsoft.com...
> Hi, Tibor Karaszi,
> yuo mean sql server case seasitive can be changed by rebuidm.exe, this is
> for sql 2000 or sql 2005?
> Thanks
> "Tibor Karaszi" wrote:
>> 1: SQL Server 2000 and earlier: Whether a password is case sensitive or not is determined by the
>> collation for the system databases (AFAIK), which was decided when you installed the SQL Server
>> instances. To change this, you need to use rebuildm.exe which will scratch all the system
>> databases,
>> and should be performed unless you have good knowledge of the SQL Server architecture and can
>> determine what such a rebuild will do.
>> 2: This is an URL for the Books Online that comes with SQL Server 2005. It is installed when you
>> install 2005, and you find an like in the SQL Server program group.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "martin1" <martin1@.discussions.microsoft.com> wrote in message
>> news:059E056C-0F3A-4DCE-AADA-9EDE468DAAE6@.microsoft.com...
>> > Hi, Tibor Karaszi,
>> >
>> > 1) if not in Sql 2005, do you know we can configute IIS web server is not
>> > case seasitive?
>> > 2) where to see
>> > ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm ?
>> > can
>> > you tell how to go there.
>> >
>> > Thanks in advance,
>> > Martin
>> >
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> >> To the best of my knowledge, you cannot change to case insensitive passwords in 2005. This
>> >> behavior
>> >> change is documented in:
>> >> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "martin1" <martin1@.discussions.microsoft.com> wrote in message
>> >> news:6108FE0B-D229-4E56-9CC9-9483AA210FC6@.microsoft.com...
>> >> > Hi, All,
>> >> >
>> >> > I just upgrade sql 2000 to sql 2005, and try to run asp webpage to access
>> >> > sql 2005 data, but the password is case seasitive. The sql 2000 is not case
>> >> > seasitive, anyone knows we can configure sql 2005 user password is not
>> >> > seasitive?
>> >> >
>> >> > Thanks for your time,
>> >> > Martin
>> >>
>> >>
>>|||Thank you so much!
Martin
"Tibor Karaszi" wrote:
> That only applies to 2000, logins are *always* case sensitive in 2005.
> If you want to try this (2000): Make sure you test this on a test server first, as I'm not 100%
> positive. But be aware that rebuildm does *a lot* of other things as well (it is pretty close to a
> re-install). This is why I mentioned that you should be very familiar with what rebuildm does and
> the consequences to running it, etc, before attempting this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> news:BF694D38-6032-4598-9CB6-4042F7D6BFC0@.microsoft.com...
> > Hi, Tibor Karaszi,
> >
> > yuo mean sql server case seasitive can be changed by rebuidm.exe, this is
> > for sql 2000 or sql 2005?
> >
> > Thanks
> >
> > "Tibor Karaszi" wrote:
> >
> >> 1: SQL Server 2000 and earlier: Whether a password is case sensitive or not is determined by the
> >> collation for the system databases (AFAIK), which was decided when you installed the SQL Server
> >> instances. To change this, you need to use rebuildm.exe which will scratch all the system
> >> databases,
> >> and should be performed unless you have good knowledge of the SQL Server architecture and can
> >> determine what such a rebuild will do.
> >>
> >> 2: This is an URL for the Books Online that comes with SQL Server 2005. It is installed when you
> >> install 2005, and you find an like in the SQL Server program group.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> >> news:059E056C-0F3A-4DCE-AADA-9EDE468DAAE6@.microsoft.com...
> >> > Hi, Tibor Karaszi,
> >> >
> >> > 1) if not in Sql 2005, do you know we can configute IIS web server is not
> >> > case seasitive?
> >> > 2) where to see
> >> > ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm ?
> >> > can
> >> > you tell how to go there.
> >> >
> >> > Thanks in advance,
> >> > Martin
> >> >
> >> >
> >> > "Tibor Karaszi" wrote:
> >> >
> >> >> To the best of my knowledge, you cannot change to case insensitive passwords in 2005. This
> >> >> behavior
> >> >> change is documented in:
> >> >> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm
> >> >>
> >> >> --
> >> >> Tibor Karaszi, SQL Server MVP
> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> http://www.solidqualitylearning.com/
> >> >>
> >> >>
> >> >> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> >> >> news:6108FE0B-D229-4E56-9CC9-9483AA210FC6@.microsoft.com...
> >> >> > Hi, All,
> >> >> >
> >> >> > I just upgrade sql 2000 to sql 2005, and try to run asp webpage to access
> >> >> > sql 2005 data, but the password is case seasitive. The sql 2000 is not case
> >> >> > seasitive, anyone knows we can configure sql 2005 user password is not
> >> >> > seasitive?
> >> >> >
> >> >> > Thanks for your time,
> >> >> > Martin
> >> >>
> >> >>
> >>
> >>
>

password case seasitive configuration

Hi, All,
I just upgrade sql 2000 to sql 2005, and try to run asp webpage to access
sql 2005 data, but the password is case seasitive. The sql 2000 is not case
seasitive, anyone knows we can configure sql 2005 user password is not
seasitive?
Thanks for your time,
MartinTo the best of my knowledge, you cannot change to case insensitive passwords
in 2005. This behavior
change is documented in:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-
cbee8013c995.htm
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"martin1" <martin1@.discussions.microsoft.com> wrote in message
news:6108FE0B-D229-4E56-9CC9-9483AA210FC6@.microsoft.com...
> Hi, All,
> I just upgrade sql 2000 to sql 2005, and try to run asp webpage to access
> sql 2005 data, but the password is case seasitive. The sql 2000 is not cas
e
> seasitive, anyone knows we can configure sql 2005 user password is not
> seasitive?
> Thanks for your time,
> Martin|||Hi, Tibor Karaszi,
1) if not in Sql 2005, do you know we can configute IIS web server is not
case seasitive?
2) where to see
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-
cbee8013c995.htm ? can you tell how to go there.
Thanks in advance,
Martin
"Tibor Karaszi" wrote:

> To the best of my knowledge, you cannot change to case insensitive passwor
ds in 2005. This behavior
> change is documented in:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b54
7-cbee8013c995.htm
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> news:6108FE0B-D229-4E56-9CC9-9483AA210FC6@.microsoft.com...
>|||1: SQL Server 2000 and earlier: Whether a password is case sensitive or not
is determined by the
collation for the system databases (AFAIK), which was decided when you insta
lled the SQL Server
instances. To change this, you need to use rebuildm.exe which will scratch a
ll the system databases,
and should be performed unless you have good knowledge of the SQL Server arc
hitecture and can
determine what such a rebuild will do.
2: This is an URL for the Books Online that comes with SQL Server 2005. It i
s installed when you
install 2005, and you find an like in the SQL Server program group.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"martin1" <martin1@.discussions.microsoft.com> wrote in message
news:059E056C-0F3A-4DCE-AADA-9EDE468DAAE6@.microsoft.com...[vbcol=seagreen]
> Hi, Tibor Karaszi,
> 1) if not in Sql 2005, do you know we can configute IIS web server is not
> case seasitive?
> 2) where to see
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b54
7-cbee8013c995.htm ? can
> you tell how to go there.
> Thanks in advance,
> Martin
>
> "Tibor Karaszi" wrote:
>|||Hi, Tibor Karaszi,
yuo mean sql server case seasitive can be changed by rebuidm.exe, this is
for sql 2000 or sql 2005?
Thanks
"Tibor Karaszi" wrote:

> 1: SQL Server 2000 and earlier: Whether a password is case sensitive or no
t is determined by the
> collation for the system databases (AFAIK), which was decided when you ins
talled the SQL Server
> instances. To change this, you need to use rebuildm.exe which will scratch
all the system databases,
> and should be performed unless you have good knowledge of the SQL Server a
rchitecture and can
> determine what such a rebuild will do.
> 2: This is an URL for the Books Online that comes with SQL Server 2005. It
is installed when you
> install 2005, and you find an like in the SQL Server program group.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> news:059E056C-0F3A-4DCE-AADA-9EDE468DAAE6@.microsoft.com...
>|||That only applies to 2000, logins are *always* case sensitive in 2005.
If you want to try this (2000): Make sure you test this on a test server fir
st, as I'm not 100%
positive. But be aware that rebuildm does *a lot* of other things as well (i
t is pretty close to a
re-install). This is why I mentioned that you should be very familiar with w
hat rebuildm does and
the consequences to running it, etc, before attempting this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"martin1" <martin1@.discussions.microsoft.com> wrote in message
news:BF694D38-6032-4598-9CB6-4042F7D6BFC0@.microsoft.com...[vbcol=seagreen]
> Hi, Tibor Karaszi,
> yuo mean sql server case seasitive can be changed by rebuidm.exe, this is
> for sql 2000 or sql 2005?
> Thanks
> "Tibor Karaszi" wrote:
>|||Thank you so much!
Martin
"Tibor Karaszi" wrote:

> That only applies to 2000, logins are *always* case sensitive in 2005.
> If you want to try this (2000): Make sure you test this on a test server f
irst, as I'm not 100%
> positive. But be aware that rebuildm does *a lot* of other things as well
(it is pretty close to a
> re-install). This is why I mentioned that you should be very familiar with
what rebuildm does and
> the consequences to running it, etc, before attempting this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> news:BF694D38-6032-4598-9CB6-4042F7D6BFC0@.microsoft.com...
>

password case seasitive configuration

Hi, All,
I just upgrade sql 2000 to sql 2005, and try to run asp webpage to access
sql 2005 data, but the password is case seasitive. The sql 2000 is not case
seasitive, anyone knows we can configure sql 2005 user password is not
seasitive?
Thanks for your time,
Martin
Hi, Tibor Karaszi,
1) if not in Sql 2005, do you know we can configute IIS web server is not
case seasitive?
2) where to see
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm ? can you tell how to go there.
Thanks in advance,
Martin
"Tibor Karaszi" wrote:

> To the best of my knowledge, you cannot change to case insensitive passwords in 2005. This behavior
> change is documented in:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> news:6108FE0B-D229-4E56-9CC9-9483AA210FC6@.microsoft.com...
>
|||Hi, Tibor Karaszi,
yuo mean sql server case seasitive can be changed by rebuidm.exe, this is
for sql 2000 or sql 2005?
Thanks
"Tibor Karaszi" wrote:

> 1: SQL Server 2000 and earlier: Whether a password is case sensitive or not is determined by the
> collation for the system databases (AFAIK), which was decided when you installed the SQL Server
> instances. To change this, you need to use rebuildm.exe which will scratch all the system databases,
> and should be performed unless you have good knowledge of the SQL Server architecture and can
> determine what such a rebuild will do.
> 2: This is an URL for the Books Online that comes with SQL Server 2005. It is installed when you
> install 2005, and you find an like in the SQL Server program group.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> news:059E056C-0F3A-4DCE-AADA-9EDE468DAAE6@.microsoft.com...
>
|||Thank you so much!
Martin
"Tibor Karaszi" wrote:

> That only applies to 2000, logins are *always* case sensitive in 2005.
> If you want to try this (2000): Make sure you test this on a test server first, as I'm not 100%
> positive. But be aware that rebuildm does *a lot* of other things as well (it is pretty close to a
> re-install). This is why I mentioned that you should be very familiar with what rebuildm does and
> the consequences to running it, etc, before attempting this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> news:BF694D38-6032-4598-9CB6-4042F7D6BFC0@.microsoft.com...
>