Loading

MSDE authorizations ?

massiot

I created a SQL database under NETSDK, using visual studio 2003 and want to use it in a web aspx page I created the dataadapter and datagrid in a web page but I get the following error message when running the page : fail to connect with username 'MACHINE\ASPNET' How can I grant authorization to the ASPNET user ? Thanks in advance Dominique Massiot

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

spgilmore22y ago
It sounds like you put 'Machine\aspnet' in the user ID part of the connection string, where it should be the data source. Double-check that. If it still gives you trouble, maybe you should post your connection string (for security, don't include the real machine name or password).