Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim myconnection As SqlConnection
Dim mycommand As SqlCommand
Dim ra As Integer
myconnection = New SqlConnection("server=IAI-004;uid=;pwd=;database=payroll")
myconnection.Open()
mycommand = New SqlCommand("INSERT INTO employee_info([employee_id],[first_name],[last_name],[middle_name],[email],[telephone],[gender],[status],[date_birth],[hire_date]) values ('" & Employee_idTextBox.Text & "','" & First_nameTextBox.Text & "','" & Last_nameTextBox.Text & "','" & Middle_nameTextBox.Text & "','" & EmailTextBox.Text & "','" & TelephoneTextBox.Text & "','" & GenderTextBox.Text & "','" & StatusTextBox.Text & "','" & Date_birthDateTimePicker.Text & "','" & Hire_dateDateTimePicker.Text & "')", myconnection)
mycommand.ExecuteNonQuery()
MessageBox.Show("New Row Inserted" & ra)
myconnection.Close()
End Sub
INSERT permission was denied on the object 'employee_info', database 'payroll' schema dbo
how can i resolve this problem?
You'll need to do this (presumably) in SQL-Server (SSMS).
Right-click the table in SQL-Server and give INSERT permissions to the user.
(...)
BTW -- you can do this via TSQL directly, but if you're having this problem now (you mention that you're new), then maybe start with the GUI, per above first.
Also -- this assumes you have access to do this in SSMS. If you're not the DBA / DBO, then you might need to contact somebody... :-)
Right Click on the Application Pool concerned. Click Advanced Settings Indentify Identity, Select LocalSystem
That should do the job.
If Answer provided previously works, then it means everytime the password changes, which must change in a normal Enterprise, you will need to update these connection strings as well, and you dont want to do that.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With