I want to create a SQL login in SQL2005. I tried creating it but it gives me error message [COLOR="Red"]"Create failed for login 'username'. User does not have permissions to perform this actions"[/COLOR] What to do now to create a SQL login in sql 2005

Member Avatar
Member Avatar
+0 forum 1

hi i am trying to convert data from excel sheet to dataset\datatable using sqlserver2005 as backend, so anybody can help me . Thanx in advance.

Member Avatar
+0 forum 0

What is the problem with the following login code? [code] Dim conn As SqlCommand = New SqlCommand("Data Source=RAHUL-034890AF0\SERVER2005;Initial Catalog=user_accounts;Integrated Security=True") conn.Prepare() Dim command As Data.SqlClient.SqlCommand = New Data.SqlClient.SqlCommand("select", conn.Connection) command.Parameters(1).Value = txtusername.Text command.Parameters(2).Value = txtpass.Text Dim i As Integer = command.ExecuteNonQuery conn.BeginExecuteNonQuery() If Page.IsValid Then Response.Redirect("~/salesbill.aspx") Else Lblerror.Text = "Username and password do not match" End If conn.Dispose() [/code] I have tested the query and it works fine. The following is the error, which seems to be related to prepare statement. Im using SQL2005 and Vwd2008. The following is the error page: Object reference not set to an instance of …

Member Avatar
Member Avatar
+0 forum 3

I have created a form in which there are various values such as Name, Address, Date of Birth etc. The user is also allowed to select an image in a picture box. I want to insert these values along with the Image into database in appropriate columns. Any help is appreciated

Member Avatar
Member Avatar
+0 forum 1

Hello Everybody, I have used inner join with two tables to join them and tried to calculate the sum of rows. Now the table descriptions are- Table1- agent_business_collection (it stores business collection of an agent of different business packages) Table2 - agent_business_commission (it stores commission of an agent against different business packages) Now, I want to calculate total business collection and commission for a particular agent. I am using the following query to do the task. select agent_business_collection.agent_code,agent_business_collection.business_pkg_ref,sum(agent_business_collection.self_amount),sum(agent_business_commission.self_comm_amt) from agent_business_collection inner join agent_business_commission on agent_business_collection.business_pkg_ref=agent_business_commission.business_pkg_ref where agent_business_collection.agent_code='100004' group by agent_business_collection.agent_code,agent_business_collection.business_pkg_ref But after executing, it returns garbage total. What I am …

Member Avatar
Member Avatar
+0 forum 2

Can someone help and show me how to display using (VB.net) these two tables combined into one. I'm really struggling trying to figure this out after hours of work, I decided its time to ask for help! So in SQL Server 2005 I have the following tables... [B]Students[/B] PKId Cart_Id Fname Lname Credits (will not always equal one) [B]Items_Ordered[/B] PkId Cart_Id Product_Id Quantity (will always be one) The following is what has to happen... The total amount of credits should always equal the total quantity of items ordered for that Cart_Id. Now, the amount of Students there are for each …

Member Avatar
Member Avatar
+0 forum 2

:'( Hello everyone, i wrote an application that makes database backups and zips them. Can anyone please tell me what i need to do in order to get the apllication to work on IIS 6 windows server 2003 SQL 05 1. The application works fine on machines for both XP and VISTA. 2. The application runs fine on Win Server 2003 however : my problem is : obviously the database is in use by the web site. How can i give my application permission to make the backup while the website is connected to the database ? regards,

Member Avatar
Member Avatar
+0 forum 5

The End.