Post reply

Correct install procedures

  • August 4, 2005 at 6:25 am

    #167832

    Greetings all

    Could someone please point me in the right direction re the installation of SQL Server.

    I will be using it in conjunction with Visual Studio 2003, as a development tool.

    I realise that there is a lot to learn about SQL server, but i cannot seen to get my applications to connect to the DB's that I create in my project files.

    I have been pointed to the authorization section of SQL server, but to be honest , I really do not have a clue, how to proceed.

    I appreciate any help or advice that can be given

    Regards

    Steve

  • August 4, 2005 at 11:03 am

    #579726

    What problems are you having exactly?

    How are you trying to connect to sql server?

    Do you have the proper credentials created in sql server?

    In sql server you need to grant a user, or user group access to the sql server. Go to the Security folder under your server in enterprise manager.

    you can either use windows authentication (recommended)

    or you can use sql server auth. (If you use this, then in enterprise manager right click on the server name, select properties, go to the security tab. Make sure sql server, and windows is selected if you have to change the value, then you will have to stop and restart mssql service for change to take effect.)

    Add a Login: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_9m0e.asp

     

     

     

  • August 5, 2005 at 10:25 am

    #580106

     

    Server Error in '/MoonRaker' Application.

    Login failed for user 'SN153800920129\ASPNET'.

    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: Login failed for user 'SN153800920129\ASPNET'.

    Source Error: 

    Line 52:         SqlCommand1.Parameters("@Username").Value = txtUsername.TextLine 53:         SqlCommand1.Parameters("@Password").Value = txtPassword.TextLine 54:         SqlConnection1.Open()Line 55:         SqlCommand1.ExecuteNonQuery()Line 56:         intResult = SqlCommand1.Parameters("@RETURN_VALUE").Value

    Source File: c:\inetpub\wwwroot\MoonRaker\Default.aspx.vb    Line: 54

    Stack Trace: 

    [SqlException: Login failed for user 'SN153800920129\ASPNET'.]   System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)   System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)   System.Data.SqlClient.SqlConnection.Open()   MoonRaker.WebForm1.Button1_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\MoonRaker\Default.aspx.vb:54   System.Web.UI.WebControls.Button.OnClick(EventArgs e)   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)   System.Web.UI.Page.ProcessRequestMain()

    Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply