Attach Database Basic Question

When one of our clients tries to attach a database (about 6GB in size)
she gets a message saying file size limit exceeded. She is using Sql
Server 2000. Is there a limitation on size for Sql Server 2000? I know
for MSDE the size can not be more than 2GB. Can you shed any light on
the issue please?Strange, and is there enough space on the file system for the database?
"S Chapman" <s_chapman47@.hotmail.co.uk> wrote in message
news:1147856960.608383.244690@.i39g2000cwa.googlegroups.com...
>
> When one of our clients tries to attach a database (about 6GB in size)
> she gets a message saying file size limit exceeded. She is using Sql
> Server 2000. Is there a limitation on size for Sql Server 2000? I know
> for MSDE the size can not be more than 2GB. Can you shed any light on
> the issue please?
>|||Sounds like your client is using MSDE or SQL Server which has limit of data
storage for a database
(2 vs 4 GB).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"S Chapman" <s_chapman47@.hotmail.co.uk> wrote in message
news:1147856960.608383.244690@.i39g2000cwa.googlegroups.com...
>
> When one of our clients tries to attach a database (about 6GB in size)
> she gets a message saying file size limit exceeded. She is using Sql
> Server 2000. Is there a limitation on size for Sql Server 2000? I know
> for MSDE the size can not be more than 2GB. Can you shed any light on
> the issue please?
>

Attach a database

Yesterday, I found I could not do a select into in my development staging
database. I received the following message...
Server: Msg 9001, Level 21, State 3, Line 266
The log for database 'DB_ST' is not available.
Connection Broken
I found that there was no log file!!! I have no idea why not. So I decided
to try to detach the database and re-attach using sp_attach_single_file_db a
s
follows and received...
USE MASTER
EXEC sp_attach_single_file_db @.dbname = 'DB_ST',
@.physname = 'D:\Databases\DB_ST_DATA.mdf'
Server: Msg 5105, Level 16, State 4, Line 1
Device activation error. The physical file name
'D:\Databases\QUINN_ST_DATA.mdf' may be incorrect.
Now I am stumped with no database and log. I have just called the
applications manager who thinks we may need to restore from another
environment. I question whether he backed up the development environment!!!!
!
Is this the only option I have?Yes. sp_attach_single_file_db might is only guaranteed to work if you detach
properly the database with sp_detach_db first, that is with the log file
still there. In other situation, like the one you have, it might work
sometimes, but is far from guaranteed. In that case you need to restore from
a backup.
Jacco Schalkwijk
SQL Server MVP
"marcmc" <marcmc@.discussions.microsoft.com> wrote in message
news:EDB0B871-2BFD-4720-9896-395234B36662@.microsoft.com...
> Yesterday, I found I could not do a select into in my development staging
> database. I received the following message...
> Server: Msg 9001, Level 21, State 3, Line 266
> The log for database 'DB_ST' is not available.
> Connection Broken
> I found that there was no log file!!! I have no idea why not. So I decided
> to try to detach the database and re-attach using sp_attach_single_file_db
> as
> follows and received...
> USE MASTER
> EXEC sp_attach_single_file_db @.dbname = 'DB_ST',
> @.physname = 'D:\Databases\DB_ST_DATA.mdf'
> Server: Msg 5105, Level 16, State 4, Line 1
> Device activation error. The physical file name
> 'D:\Databases\QUINN_ST_DATA.mdf' may be incorrect.
> Now I am stumped with no database and log. I have just called the
> applications manager who thinks we may need to restore from another
> environment. I question whether he backed up the development
> environment!!!!!
> Is this the only option I have?|||Thanks Jacco... I thought that would be the case.
"Jacco Schalkwijk" wrote:

> Yes. sp_attach_single_file_db might is only guaranteed to work if you deta
ch
> properly the database with sp_detach_db first, that is with the log file
> still there. In other situation, like the one you have, it might work
> sometimes, but is far from guaranteed. In that case you need to restore fr
om
> a backup.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "marcmc" <marcmc@.discussions.microsoft.com> wrote in message
> news:EDB0B871-2BFD-4720-9896-395234B36662@.microsoft.com...
>
>sql

attach Help

I received three Files .mdf .ldf .ndf and a text how to use attach
but i always receive an error message "database is write protect ......"
What I do wrong ?
byeFirst of all, what did you do?|||Are the three files read-only at the O/S level? This can happen if the three files were sent as attachments in e-mail.|||could it be that the database already exists and in read-only mode?|||Are we even talking about SQL Server?

And when does the damn weekend start already.....

DECLARE @.Weekend datetime
SELECT @.Weekend = 'Jan 16 2004 17:00:00'
SELECT DATEDIFF(mi, GetDate(), @.Weekend)/60.00 As Hours_till_Margaritaville|||Sorry for mistakes
I'll start again
i have 3 Files xxx.mdf,xxx.ndf,xxx.ldf from originally sql7 ,from network and I'd like to atach to Sqlserver 2000; on sql server 2000 is the database not present
With Query Analyzer I tested i did:
Exec sp_attach_db
@.dbname="xxx",
@.filename1= "xxx.mdf",
@.filename2= "xxx.ndf",
@.filename3= "xxx.ldf"

With Sql 2000 Manager I use The menu attach

In both case i received this message "The Database is write Protect you
have to unptrotect.......

bye|||Right click on each file in succession, go to properties, and see if any of them have the read-only checkbox marked. If so, uncheck that box.|||I checked the free file , they all are not write protect|||As a test, see if you can rename one of the files. Maybe backup software, or virus scan has it open?

I just tried a test of re-attaching a readonly filegroup, and it worked. Although, I do not have access to a 7.0 machine, anymore to try out a readonly filegroup with an upgrade.

That sparks a thought. Do you have access to the database in it's original state? That is, can you see if the original database (on SQL 7.0) is read only or had read only filegroups?|||I can rename the files, and I open the file .ndf with an Hex editor
there are more line with read only inside the file

bye

Assistance with error message

I am trying to run this script in Query Analyser and it seems to have a
problem in line 3:
-
select ID, 9, '2004', (select id from type where type = 'MF') from Dept
where dept in ('Internal Medicine', 'Surgery')
and ID + (select id from type where type = 'MF') +
convert(varchar(2), 9) +
convert(varchar(4), '2004')
not in
(select m.deptID + m.typeid + convert(varchar(2), m.dtmonth) +
convert(varchar(4), m.dtyear) from monthdept m, dept d, type t
where m.DeptID *= d.ID
and m.TypeID *= t.Type
)
The error message is: Invalid operator for data type. Operator equals add,
type equals uniqueidentifier.
I have tried playing with CAST/CONVERT without success. I am trying to look
for records on a key that spans 4 fields. Any suggestions/thoughts?
Schoo
PS: SQL Server 2000 running on W2K Server
Hi Schoo,
From your descriptions, I understood that the following codes raise an
error in QA, correct me if I was wrong, however, when I copied codes you
provided to my QA and then Parse Query (Ctrl + F5), it passed. To make
further research on this issue, I would appreciated if you could provide me
detailed DDL of your database and some sample record for me to reporduce it
on my machine. One more question, have you upgraded to the latest SQL
Server Service Pack?
Here is the document on how to get DDL from Enterprise Manager
Please provide DDL and sample data.
http://www.aspfaq.com/etiquette.asp?id=5006
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Assert Permission - ISSUE.

Hi All,
I am using a .net dll in my RDL, I have done all the steps to implement the
custom assembly in the report.
--
Message posted via http://www.sqlmonster.comLook at this thread, you have to get Reporting Services trust your DLL.
http://groups.google.de/groups?hl=de&lr=&threadm=OAxg3EQRFHA.4028%40tk2msftngp13.phx.gbl&rnum=1&prev=/groups%3Fq%3Dreporting%2Bservices%2Bassembly%2Bgac%26hl%3Dde%26lr%3D%26scoring%3Dd%26selm%3DOAxg3EQRFHA.4028%2540tk2msftngp13.phx.gbl%26rnum%3D1
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"BALAJI KRISHNAN via SQLMonster.com" <forum@.nospam.SQLMonster.com> schrieb
im Newsbeitrag news:25b6837f5aaf4a7589ef4ac1bd3cd615@.SQLMonster.com...
> Hi All,
> I am using a .net dll in my RDL, I have done all the steps to implement
> the
> custom assembly in the report.
> --
> Message posted via http://www.sqlmonster.com|||Sorry hit the Post Message button... Remaining Message...
I have done all the steps...
Step 1) Copying the dll to the C:\Program Files\Microsoft SQL Server\MSSQL\
Reporting Services\ReportServer\bin\
and
C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer\ - Folders
Step 2) Create Permission Set and Code Group and changing the
rssrvpolicy.config file...
See my Permission Set and Code Group added to the file
<PermissionSet class="NamedPermissionSet"
version="1"
Name="CCPermissionSet">
<IPermission class="SecurityPermission"
version="1"
Flags="Assertion, Execution"/>
</PermissionSet>
<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="CCPermissionSet"
Name="CCCodeGroup"
Description="">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="file://C:/Program
Files/Microsoft SQL Server/MSSQL/Reporting
Services/ReportServer/bin/CreditCardDecrypt.dll"/>
</CodeGroup>
Step 3) Refering the dll in the RDL (Properties - Reference - map dll)
Step 4) This is the Important step...Where I am missing...I need to give
the Assert permission to my code..I dont know what Assert Permission I need
to give for my dll...(As we give for SqlClientPermission...)
See my dll code...
public static string DecryptCardInfo(string cc,string subjectName,string
storeName)
{
string sCreditCard = "";
try
{
SecurityPermission secPerm = new SecurityPermission
(PermissionState.Unrestricted);
secPerm.Assert();
WSEX509.X509CertificateStore.StoreLocation location =WSEX509.X509CertificateStore.StoreLocation.CurrentUser;
WSEX509.X509CertificateStore.StoreProvider provider =WSEX509.X509CertificateStore.StoreProvider.System;
WSEX509.X509CertificateStore store = new WSEX509.X509CertificateStore
(provider, location, storeName);
bool fopen = store.OpenRead();
if(fopen)
{
WSEX509.X509CertificateCollection certs =store.FindCertificateBySubjectString(subjectName);
if (certs.Count > 0)
{
WSEX509.X509Certificate cer = certs[0];
WSECRY.RSACryptoServiceProvider rsaCsp =(WSECRY.RSACryptoServiceProvider)cer.Key;
byte[] cipherData = Convert.FromBase64String(cc);
byte[] plainData = rsaCsp.Decrypt(cipherData, false);
sCreditCard = Encoding.UTF8.GetString(plainData);
}
}
if (store != null)
store.Close();
return sCreditCard;
//return cc;
}
catch(Exception ex)
{
return ex.ToString();
}
}
}
I am in Need your help Immediately..because I am stuck with this for the
past days..and have no clue for this...
If you need any more information please send a note I can give u
immediately...
Thanks in advance...
balaji.
--
Message posted via http://www.sqlmonster.com|||Try to place you DLL in the GAC to identify wheter it is a security problem.
"BALAJI KRISHNAN via SQLMonster.com" <forum@.SQLMonster.com> schrieb im
Newsbeitrag news:7f6dadd296e74d5a9a51a62bac995613@.SQLMonster.com...
> Sorry hit the Post Message button... Remaining Message...
> I have done all the steps...
> Step 1) Copying the dll to the C:\Program Files\Microsoft SQL
> Server\MSSQL\
> Reporting Services\ReportServer\bin\
> and
> C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer\ - Folders
> Step 2) Create Permission Set and Code Group and changing the
> rssrvpolicy.config file...
> See my Permission Set and Code Group added to the file
> <PermissionSet class="NamedPermissionSet"
> version="1"
> Name="CCPermissionSet">
> <IPermission class="SecurityPermission"
> version="1"
> Flags="Assertion, Execution"/>
> </PermissionSet>
> <CodeGroup class="UnionCodeGroup"
> version="1"
> PermissionSetName="CCPermissionSet"
> Name="CCCodeGroup"
> Description="">
> <IMembershipCondition class="UrlMembershipCondition"
> version="1"
> Url="file://C:/Program
> Files/Microsoft SQL Server/MSSQL/Reporting
> Services/ReportServer/bin/CreditCardDecrypt.dll"/>
> </CodeGroup>
>
> Step 3) Refering the dll in the RDL (Properties - Reference - map dll)
> Step 4) This is the Important step...Where I am missing...I need to give
> the Assert permission to my code..I dont know what Assert Permission I
> need
> to give for my dll...(As we give for SqlClientPermission...)
>
> See my dll code...
> public static string DecryptCardInfo(string cc,string subjectName,string
> storeName)
> {
> string sCreditCard = "";
> try
> {
> SecurityPermission secPerm = new SecurityPermission
> (PermissionState.Unrestricted);
> secPerm.Assert();
> WSEX509.X509CertificateStore.StoreLocation location => WSEX509.X509CertificateStore.StoreLocation.CurrentUser;
> WSEX509.X509CertificateStore.StoreProvider provider => WSEX509.X509CertificateStore.StoreProvider.System;
> WSEX509.X509CertificateStore store = new WSEX509.X509CertificateStore
> (provider, location, storeName);
> bool fopen = store.OpenRead();
> if(fopen)
> {
> WSEX509.X509CertificateCollection certs => store.FindCertificateBySubjectString(subjectName);
> if (certs.Count > 0)
> {
> WSEX509.X509Certificate cer = certs[0];
> WSECRY.RSACryptoServiceProvider rsaCsp => (WSECRY.RSACryptoServiceProvider)cer.Key;
> byte[] cipherData = Convert.FromBase64String(cc);
> byte[] plainData = rsaCsp.Decrypt(cipherData, false);
> sCreditCard = Encoding.UTF8.GetString(plainData);
> }
> }
> if (store != null)
> store.Close();
> return sCreditCard;
> //return cc;
> }
> catch(Exception ex)
> {
> return ex.ToString();
> }
> }
> }
>
> I am in Need your help Immediately..because I am stuck with this for the
> past days..and have no clue for this...
> If you need any more information please send a note I can give u
> immediately...
> Thanks in advance...
> balaji.
> --
> Message posted via http://www.sqlmonster.com|||Hi Jens,
I have placed the dll in the GAC sucessfully.
But still I got #Error...
Balaji
--
Message posted via http://www.sqlmonster.com|||CAN MICROSOFT FOLKS HELP ON THIS....
STILL FACING THE ISSSUE..
THANKS IN ADVANCE
BALAJI
--
Message posted via http://www.sqlmonster.com|||Hi Balaji,
Is your problem is solve of acessing .net dll in reporting service.
I am also having the same problem where my .Net dll reads the config file to
get another file URL which has stored another file URL and using this new URL
(XML file) i am accessing the result through XMldocument and returing the
result back. But the security issue is the main issue which i am not able to
solve. If you can help me out i'll be helpful to you.
Thanks
Jasvinder
"BALAJI KRISHNAN via SQLMonster.com" wrote:
> Hi All,
> I am using a .net dll in my RDL, I have done all the steps to implement the
> custom assembly in the report.
> --
> Message posted via http://www.sqlmonster.com
>

ASP.net app error after changing sa password

Hello,
I changed the sa password and now i get the error message below. I
cannot find the old password and do not know how to change it in the
system to allow it to succelfully authenticate again.
I'm running iis on a local network with an asp app. It tries to
connect to the sql database for the customer info.
Any help would be much appreciated. jho
error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
for user 'sa'
Hi
You should not be using sa as a login for a web application, the account
will be in the connection string which could be in one of several locations
see http://msdn2.microsoft.com/en-us/library/aa302392.aspx for more.
John
"jho" <jhogan0101@.yahoo.com> wrote in message
news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
> Hello,
> I changed the sa password and now i get the error message below. I
> cannot find the old password and do not know how to change it in the
> system to allow it to succelfully authenticate again.
> I'm running iis on a local network with an asp app. It tries to
> connect to the sql database for the customer info.
> Any help would be much appreciated. jho
> error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
> for user 'sa'
|||Hi
You should not be using sa as a login for a web application, the account
will be in the connection string which could be in one of several locations
see http://msdn2.microsoft.com/en-us/library/aa302392.aspx for more.
John
"jho" <jhogan0101@.yahoo.com> wrote in message
news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
> Hello,
> I changed the sa password and now i get the error message below. I
> cannot find the old password and do not know how to change it in the
> system to allow it to succelfully authenticate again.
> I'm running iis on a local network with an asp app. It tries to
> connect to the sql database for the customer info.
> Any help would be much appreciated. jho
> error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
> for user 'sa'
|||Hi
You should not be using sa as a login for a web application, the account
will be in the connection string which could be in one of several locations
see http://msdn2.microsoft.com/en-us/library/aa302392.aspx for more.
John
"jho" <jhogan0101@.yahoo.com> wrote in message
news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
> Hello,
> I changed the sa password and now i get the error message below. I
> cannot find the old password and do not know how to change it in the
> system to allow it to succelfully authenticate again.
> I'm running iis on a local network with an asp app. It tries to
> connect to the sql database for the customer info.
> Any help would be much appreciated. jho
> error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
> for user 'sa'
|||On Jan 13, 3:39Xpm, "John Bell" <jbellnewspo...@.hotmail.com> wrote:
> Hi
> You should not be using sa as a login for a web application, the account
> will be in the connection string which could be in one of several locations
> see Xhttp://msdn2.microsoft.com/en-us/library/aa302392.aspxfor more.
> John"jho" <jhogan0...@.yahoo.com> wrote in message
> news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
>
>
> - Show quoted text -
I am trying to change to nt authentication but it seems like it has no
effect when i change it in the "logins" section in sql enterprise
manager and iis. FYI i am a network guy who knows very little about
dbs' and sql but trying. I was initially trying to access the db from
a network pc when i changed or maybe enabled the sa password to gain
access for a mail merge. How do i undo this?
|||Hi
You would need to change the connection string in your ASP page to be
trusted authentication.
John
"jho" <jhogan0101@.yahoo.com> wrote in message
news:4b58f408-4194-4b19-bc8d-a60f46d5eb2e@.s8g2000prg.googlegroups.com...
On Jan 13, 3:39 pm, "John Bell" <jbellnewspo...@.hotmail.com> wrote:
> Hi
> You should not be using sa as a login for a web application, the account
> will be in the connection string which could be in one of several
> locations
> see http://msdn2.microsoft.com/en-us/library/aa302392.aspxfor more.
> John"jho" <jhogan0...@.yahoo.com> wrote in message
> news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
>
>
> - Show quoted text -
I am trying to change to nt authentication but it seems like it has no
effect when i change it in the "logins" section in sql enterprise
manager and iis. FYI i am a network guy who knows very little about
dbs' and sql but trying. I was initially trying to access the db from
a network pc when i changed or maybe enabled the sa password to gain
access for a mail merge. How do i undo this?

ASP.net app error after changing sa password

Hello,
I changed the sa password and now i get the error message below. I
cannot find the old password and do not know how to change it in the
system to allow it to succelfully authenticate again.
I'm running iis on a local network with an asp app. It tries to
connect to the sql database for the customer info.
Any help would be much appreciated. jho
error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
for user 'sa'Hi
You should not be using sa as a login for a web application, the account
will be in the connection string which could be in one of several locations
see http://msdn2.microsoft.com/en-us/library/aa302392.aspx for more.
John
"jho" <jhogan0101@.yahoo.com> wrote in message
news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
> Hello,
> I changed the sa password and now i get the error message below. I
> cannot find the old password and do not know how to change it in the
> system to allow it to succelfully authenticate again.
> I'm running iis on a local network with an asp app. It tries to
> connect to the sql database for the customer info.
> Any help would be much appreciated. jho
> error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
> for user 'sa'|||Hi
You should not be using sa as a login for a web application, the account
will be in the connection string which could be in one of several locations
see http://msdn2.microsoft.com/en-us/library/aa302392.aspx for more.
John
"jho" <jhogan0101@.yahoo.com> wrote in message
news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
> Hello,
> I changed the sa password and now i get the error message below. I
> cannot find the old password and do not know how to change it in the
> system to allow it to succelfully authenticate again.
> I'm running iis on a local network with an asp app. It tries to
> connect to the sql database for the customer info.
> Any help would be much appreciated. jho
> error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
> for user 'sa'|||Hi
You should not be using sa as a login for a web application, the account
will be in the connection string which could be in one of several locations
see http://msdn2.microsoft.com/en-us/library/aa302392.aspx for more.
John
"jho" <jhogan0101@.yahoo.com> wrote in message
news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
> Hello,
> I changed the sa password and now i get the error message below. I
> cannot find the old password and do not know how to change it in the
> system to allow it to succelfully authenticate again.
> I'm running iis on a local network with an asp app. It tries to
> connect to the sql database for the customer info.
> Any help would be much appreciated. jho
> error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
> for user 'sa'|||On Jan 13, 3:39=A0pm, "John Bell" <jbellnewspo...@.hotmail.com> wrote:
> Hi
> You should not be using sa as a login for a web application, the account
> will be in the connection string which could be in one of several location=s
> see =A0http://msdn2.microsoft.com/en-us/library/aa302392.aspxfor more.
> John"jho" <jhogan0...@.yahoo.com> wrote in message
> news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
>
> > Hello,
> > I changed the sa password and now i get the error message below. I
> > cannot find the old password and do not know how to change it in the
> > system to allow it to succelfully authenticate again.
> > I'm running iis on a local network with an asp app. It tries to
> > connect to the sql database for the customer info.
> > Any help would be much appreciated. jho
> > error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
> > for user 'sa'- Hide quoted text -
> - Show quoted text -
I am trying to change to nt authentication but it seems like it has no
effect when i change it in the "logins" section in sql enterprise
manager and iis. FYI i am a network guy who knows very little about
dbs' and sql but trying. I was initially trying to access the db from
a network pc when i changed or maybe enabled the sa password to gain
access for a mail merge. How do i undo this?|||Hi
You would need to change the connection string in your ASP page to be
trusted authentication.
John
"jho" <jhogan0101@.yahoo.com> wrote in message
news:4b58f408-4194-4b19-bc8d-a60f46d5eb2e@.s8g2000prg.googlegroups.com...
On Jan 13, 3:39 pm, "John Bell" <jbellnewspo...@.hotmail.com> wrote:
> Hi
> You should not be using sa as a login for a web application, the account
> will be in the connection string which could be in one of several
> locations
> see http://msdn2.microsoft.com/en-us/library/aa302392.aspxfor more.
> John"jho" <jhogan0...@.yahoo.com> wrote in message
> news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
>
> > Hello,
> > I changed the sa password and now i get the error message below. I
> > cannot find the old password and do not know how to change it in the
> > system to allow it to succelfully authenticate again.
> > I'm running iis on a local network with an asp app. It tries to
> > connect to the sql database for the customer info.
> > Any help would be much appreciated. jho
> > error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
> > for user 'sa'- Hide quoted text -
> - Show quoted text -
I am trying to change to nt authentication but it seems like it has no
effect when i change it in the "logins" section in sql enterprise
manager and iis. FYI i am a network guy who knows very little about
dbs' and sql but trying. I was initially trying to access the db from
a network pc when i changed or maybe enabled the sa password to gain
access for a mail merge. How do i undo this?