Going a bit crazy. Have sqlserver all installed and running. I have a
security problem I think- have read many other news posts that SOUND
similar but e.g. My SQL Server configuration manager doesnt seem to
have seccurity options let alone offer the possibility of allowing a
'mix' of SQL/ windows requests.
For logon in SQL Server configuration manager 'built- in account'
local system is selected rather than the 'this account' option which
has stars in the password field and no username options.
This is myconnection string: kris\ is this local machine
myConnection = New SqlConnection(" server=kris
\SQLEXPRESS;uid =sa;pwd=;databa se=pubs")
This is the error I get
System.Data.Sql Client.SqlExcep tion was unhandled
Class=14
ErrorCode=-2146232060
LineNumber=6553 6
Message="Login failed for user 'sa'. The user is not associated with
a trusted SQL Server connection."
Number=18452
Procedure=""
Server="krislap top\SQLEXPRESS"
Any ideas?
security problem I think- have read many other news posts that SOUND
similar but e.g. My SQL Server configuration manager doesnt seem to
have seccurity options let alone offer the possibility of allowing a
'mix' of SQL/ windows requests.
For logon in SQL Server configuration manager 'built- in account'
local system is selected rather than the 'this account' option which
has stars in the password field and no username options.
This is myconnection string: kris\ is this local machine
myConnection = New SqlConnection(" server=kris
\SQLEXPRESS;uid =sa;pwd=;databa se=pubs")
This is the error I get
System.Data.Sql Client.SqlExcep tion was unhandled
Class=14
ErrorCode=-2146232060
LineNumber=6553 6
Message="Login failed for user 'sa'. The user is not associated with
a trusted SQL Server connection."
Number=18452
Procedure=""
Server="krislap top\SQLEXPRESS"
Any ideas?