The error message is self explanatory - the specified SQL server was not found.

Try using the server IP address instead of the server name in case your WINS/DNS services are not working properly.

Hi EdT

WINS/DNS services are working fine. now its giving wise sql error [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open Database "GMS" requested by the login. The Login failed.

The .wsi file is attached. Is there anything wrong in the script/

Thanks

I am away at a conference at the moment, but if the message states that the login failed, then the most likely reason is that the login failed. I don't have a ZIP viewer here, so did you include a domain\username string or just a username string for the login?

HI EdT

I have used the domain\username string the while configuring ODBC it will give the error login failed.

Can you login manually?

Also, if your test machine already has a connection to the SQL server, perhaps your profile already has a connection to the server, then you will not be able to login as a different user until you logout your existing connection.

HI EdT

I can able to login manually. Using MSI script i can create ODBC data source in system DSN using command

Execute a program from destination C:\WINDOWS\system32\odbcconf.exe /a {CONFIGSYSDSN "SQL Server" "DSN=GMS|Description=System DSN to connect to GMS System|SERVER=BNG1XXRPLGMS\SQLEXPRESS|Network=DBMSSOCN|Trusted_Connection=No|Database=GMS"}

but it will not create SQL server database.

In above post attached .WSI file is there anything wrong in the script?

Thanks

It only ends up writing to the registry so your package would do betther to use the Registry table. Wise does have ODBC handling as a separate "view" but I've never bothered with it after having struggled to get it to work consistently at a client site. As I say, since this junk ends up in the registry anyway, just put it straight there.

You should also consider using public properties for the server and database names to cater for changes. Or perhaps your site is one where such things never change? Oink, flap!

Hi EdT

Thanks for information.

I was trying custom action in SYSTEM mode. I tried with USER mode its working fine.

If i run .MSI script to another machine its giving error [Microsoft][ODBC SQL Server driver][TCP/IP Sockets]Specified sql server not found.

Why this error occured?

Thanks.

HI EdT

Thanks its working fine.