[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ' '.

[Srinivas]

Hi,
I am working on a project to script all database objects.The code
below works fine on my machine( windows XP ) and all the creates all
the db objects.

But I get an error message when I run it on a server( windows server
2003).

The first part of the code where I am executing sp_dboption and
getting all the options set for the database is working fine and it
creates the required script , but the piece of code using the SQLDMO
to get the database objects is where I am getting the error.

Thanks

Srini



Code Listing :-

public class ScriptAndCreate DataBases
{
public void ConnectAndScrip tDatabases( SQLServer2Class server )
{

server.LoginSec ure = true;
server.Connect( server.Name , "sa" , "" ) ;

- - - -
foreach (Database2 d in databases )
{

ConnectAndGetOp tions( server , d.Name, options);
ScriptDBObjects dbobj = new ScriptDBObjects ();
dbobj.Initializ e(server, d);
}

- - - -


public class ScriptDBObjects
{
private SQLServer2Class m_sqlserver;
public void Initialize(SQLS erver2Class ssc , Database2 db )
{
m_sqlserver = new SQLServer2Class () ;
m_sqlserver = ssc ;
---
}

private void ScriptDatabase( Database2 db , SQLServer2Class server
{
case Db_Types.Defaul ts:
s_transfer.Copy AllDefaults = true;
GenerateScript( s_transfer, workingFolder, db );
}

private void GenerateScript( TransferClass tc, string folder, Database2
db )
{

--erroring out db.ScriptTransf er(tc,
SQLDMO_XFRSCRIP TMODE_TYPE.SQLD MOXfrFile_Singl eFilePerObject, folder);
}

[Marc Scheuner [MVP ADSI]]

Re: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ' '.

>But I get an error message when I run it on a server( windows server[color=blue]
>2003).
>
>server.LoginSe cure = true;
>server.Connect ( server.Name , "sa" , "" ) ;[/color]

Most likely, your server's SQL database is protecting the "sa" account
(System Administrator) with a password..... that's why your login
fails (I think).

Marc
=============== =============== =============== =============== ====
Marc Scheuner May The Source Be With You!
Bern, Switzerland m.scheuner(at)i nova.ch