help with connection

[chris]

hi
i created a user in sql server under login then i went to the database and under users i added the user and them gave the user permissions to select from the tables and execute the stored procedures but when i try to pass the user in my connection string i ge


Access to the remote server is denied because no login-mapping exists.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Access to the remote server is denied because no login-mapping exists

Source Error:

Line 110
Line 111: ds = New DataSe
Line 112: cmdSel.Fill(ds, "Oreg"
Line 113
Line 114: DataGrid2.DataSource = ds.Tables("Oreg").DefaultVie


Source File: D:\Projects\BNPWebsite\pos_application\WebForm2.aspx.vb Line: 112

Stack Trace:

[SqlException: Access to the remote server is denied because no login-mapping exists.
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +72
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +4
System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +30
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +7
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +3
pos_application.WebForm2.BindGrid() in D:\Projects\BNPOSWebsite\pos_application\WebForm2.aspx.vb:11
pos_application.WebForm2.Page_Load(Object sender, EventArgs e) in D:\Projects\BNPOSWebsite\pos_application\WebForm2.aspx.vb:5
System.Web.UI.Control.OnLoad(EventArgs e) +6
System.Web.UI.Control.LoadRecursive() +3
System.Web.UI.Page.ProcessRequestMain() +73



why is this. if i change the UID to sa in the connection string it works fine. is there something i missed when i created the user

thank

 

[Ravikanth[MVP]]

H

Is it Linked Server? if so add user in the following wa
http://databasejournal.com/features/mssql/article.php/311601

HT
Ravikanth[MVP]