Hi - I'm using the connect string below to connect to my MS SQL DB (all local). When i test the recorsets in Dreamweaver, all works fine. But when i browse the .asp page, i get this error!

"Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "mydatabase" requested by the login. The login failed."

As far as i'm aware, i have setup the MS SQL Database (migrated from Access DB) as 'Windows Authentication".

Anyone else experienced the same or knows what the problem is?

Thanks in advance -

Andy

-------connection string--------
Dim MM_conn_STRING
MM_conn_STRING = "Driver={SQL Server}; Server=WEBDESIGNAH\SQLEXPRESS; Database=mydatabase; UID=; PWD=;"

Check you db permissions. It could be that.