What Are The Settings To Enable Any Memeber Of An AD Group To Logon To SQL2005
Oct 3, 2005I have a group login created on the SQL server like so:
View 6 RepliesI have a group login created on the SQL server like so:
View 6 RepliesHello,
I understand that SQL2005x64 bits ignore AWE enable in SQL because it can address all the memory without having to use AWE. How about 32 bits SQL2005, does it support AWE enabled??
I run a very large dataset to print whole bunch of pages. It is giving me this error. I have done all the solutions provided in this msdn forums but still this error is cropping up.
Please help.
I've come up against a wall with regards to adding login via a windows group. My end goal is to be able to manage sysadmin access to many servers via a domain group instead of via individual logins at each server.
I've got a mix of 2000 and 2005 servers, with a related issue for each. Searching far and wide has come up empty so far.
In each case below, the a login for the group was created via EM/SSMS, and set with the sysadmin role.
1. Domain Local Group
I added a domain local group "domainsql accounts" with myself among others as members, including the domain account for the sql and agent services.
Adding this group to SQL2005 worked fine, and authenticates my login as a member of this group. Oddly, xp_logininfo [domainsql accounts] , 'members' returns error code 0x8ac.
It does log me in, and it does correctly grant me sysadmin.
Adding this group to SQL2000 from EM, the group does not appear in the list for the domain. Typing it manually does recognize it as a group, but it does not allow login.
Review:
2000 fails login, fails xp_logininfo
2005 allows login, fails xp_logininfo
2. Domain Global Group
Next, I added a global group "domainsql dba", with myself among others as members.
This group IS viewable in SQL2000 EM to add as a login. Unfortunately, I still cannot login via windows auth. Even stranger, xp_logininfo [domainsql dba] , 'members' correctly returns the members of this group. I know SQL can authenticate that group, and I am part of that group, yet it won't authenticate my login?
SQL2005 fails to allow login but will also return member info via xp_logininfo.
Review:
2000 fails login, returns xp_logininfo
2005 fails login, returns xp_logininfo
The closest thing I found was a MS kb entry that suggested creating a local group, adding the domain group as a member of the local group, and adding a login for the local group. It didn't work.
Thanks for any offered suggestions
Chris
I have come across this error message in ssrs and cannot seem to locate the error. Report manager lets me logon-- I can navigate to the folder but once I click on the actual report I get this error
and suggestions as to why and how to fix it???
Thanks in advance
I have installed visual studio 2005 with sql express. My tutorial book asked me to do the following to be able to use sql.
sqlcmd -S mycomputernameSQLExpress -E
which worked and then I get
1>
where I am to put in
1> sp_grantlogin [mycomputernamemyusername]
2> go
after this i get the error.
Msg 15401, Level 11, State 1, Server mycomputernameSQLEXPRESS, Procedure sp_grantlogin, Line 49
Windows NT user or group 'mycomputernamemyusername' not found. Check the name again.
I used Local System for the user name as that is what I think I am seeing as the right user account.
Help?
hi
i try to restore a bak file from another sql2005 server to my sql2005 server, but it show the error message as below :
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
Cannot open backup device 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupackup.bak'. Operating system error 5(error not found).
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3201&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
pls some one can help me ???
thanks
chaus
Can you open/use a database created in SQL2005 in SQL2005 Express?
Thanks for the help!
Max
I just upgraded my SQL 2000 server to SQL2005. I forked out all that money, and now it takes 4~5 seconds for a webpage to load. You can see for yourself. It's pathetic. When I ran SQL2000, i was getting instant results on any webpage. I can't find any tool to optimize the tables or databases. And when I used caused SQL Server to use 100% cpu and 500+MB of ram. I can't have this.Can anyone give me some tips as to why SQL 2005 is so slow?
View 3 Replies View RelatedHi
We have Sql2005 x64 bit standard edition server installed in windows 2003 64 bit editio server,
currently due to buisness requirements we need to have sql2005 x64 bit enterprise edition, please let me know how do i do the upgrade or change.
is it possible to retain all our custom settings in the standard edition after changing to enterprise edition.
This has to be done for our production and very critical, please help
Thanks
Samuel I
I have an SSRS 2012 table report with groups; each group is broken ie. one group for one page, and there are multiple groups in multiple pages.
'GroupName' column has multiple values - X,Y,Z,......
I need to group 'GroupName' with X,Y,Z,..... ie value X in page 1,value Y in page 2, value Z in page 3...
Now, I need to display another column (ABC) in this table report (outside the group column 'GroupName'); this outside column itself is another column header (not a group header) in the table (report) and it derives its name partly from the 'GroupName' values:
Example:
Value X for GroupName in page 1 will mean, in page 1, column Name of ABC column must be ABC-X Value Y for GroupName in page 2 will mean, in page 2, column Name of ABC column must be ABC-Y Value Z for GroupName in page 3 will mean, in page 3, column Name of
ABC column must be ABC-Z
ie the column name of ABC (Clm ABC) must be dynamic as per the GroupName values (X,Y,Z....)
Page1:
GroupName Clm ABC-X
X
Page2:
GroupName Clm ABC-Y
Y
Page3:
GroupName Clm ABC-Z
Z
I have been able to use First(ReportItems!GroupName.Value) in the Page Header to get GroupNames displayed in each page; I get X in page 1, Y in page 2, Z in page 3.....
However, when I use ReportItems (that refers to a group name) in the Report Body outside the group,
I get the following error:
Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope
I need to get the X, Y, Z ... in each page for the column ABC.
I have been able to use this - First(Fields!GroupName.Value); however, I get ABC-X, ABC-X, ABC-X in each of the pages for the ABC column, instead of ABC-X in page 1, ABC-Y in page 2, ABC-Z in page 3, ...
I am unable to install 32-bit SQL Server Integration Services on the server due to something that was left behind by the 64-bit version.
I've uninstalled SQL Server 2005 64-bit and when I try to install the 32-bit version of Integration Services, I get this error: "Failed to install and configure assemblies C:Program Files (x86)Microsoft SQL Server90DTSTasksMicrosoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2146233087 Error message: Unknown error 0x80131501 Error descrition: FATAL: Could not find component 'Microsoft.SqlServer.Dts.Task.MessageQueueTask.ServCompMQTask' we just installed."
I can't seem to figure out how to resolve this problem with the COM+ and I can't remember if Integration Services is required.
Can anybody please advise?
Hello,
I have a vb program that include a dts package that has been saved to vb with sql2000 dts wizard and works very good.
Now that I upgrade my website to sql2005, this vb dts package doesn't work.
The error I get is:
Microsoft Data Transformation Services (DTS) Package
Invalid STDGMEDIUM structure
(Microsoft Data Transformation Services (DTS) Package (80040066): Invalid STDGMEDIUM structure
) (Microsoft SQL-DMO (ODBC SQLState: 42000) (80004005): [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'.)
I searched in the internet how to make dts package in sql2005 and save it to vb and found no information about it.
What Can I do to get the vb code of the dts package I create in sql2005 or how do i migrage the sql2000 vb dts package code to sql2005?
Thanks,
Kubyustus
HelloI am getting this err msg when trying to logon to my website on the web - on my machine there is no prob, An error occurred while established a connection to the server.When connection to Sql.S 2005, this failure may be caused by the fact thatunder the default settings sql.s doesn't allow remote connection.(provider :Sql.S Network interface, error:26- Error Location Server/Interface Specified)(the files path is like in the web host s)
View 2 Replies View RelatedWhen attempting to logon to the SQL server using ODBC, Windows NT workstations get the following error code:
Connection Failed:
SQLState:`01000`
SQL Server Error:1326
...
Windows `95 stations can log on fine.
Any suggestions? Thank you in advance.
Is there a sp or an easy way to move logons from SQL6.5 to 7.0?
Thanks,
Kevin
Greetings,
After upgrading a SQL 7.0 WINNT 4.0 SP5 box to Windows 2000 SP1, SQL 2000 configuration I am getting the following error when some users try to connect to the server using Enterprise Manager;
"A connection could not be established to 'SERVERNAME'. Reason: Login failed for user 'NT AUTHORITYANONYMOUS LOGON'"
After doing some troubleshooting, I have found that this only occurs when I have the services started with a domain service account (this account is part of the domain admin global group and is a System Administrator in SQL as well) and it does not occur when the services are started with the System Account. Additionally, it also appears that this only occurs for some users and not all. However, these same users that are having problems on this server, can connect to other Database Servers using the "same" configuration.
Has anyone seen this. I have searched TechNet and found nothing that applies directly to this error. Any help that could be provided would be greatly appreciated.
I just started at a new company. The security stinks, everyone logs into the servers as sa (including many applications). I am taking steps to tighten security and restrict access to the sa login. I would like to capture some additional information at logon as an interim measure.
Can anyone assist me in automatically recording the following:
Host Name / IP Address
Login time
I realize I could periodically run an sp_who2 and capture the results - I also realize that if I turn on auditing, the logon will be written to the SQL Srvr LOG - I'm looking for an elegant / low impact way to capture the logon and host information.
Thanks in advance for any help.
Scott Wright
I was reading though my logs and noticed I had three instances of an anonymous logon last night. The last anonymous logon was at approx midnight. This is prime hacking time.
Can anyone give me direction on issues or concerns with anonymous logons.
Much thanks in advance ....
Hi and thanks in advance :)
I was playing around with logins and windows groups and did the following:
Created windows group on my local computer called SQLAdmins.
Added my domain user to this SQLAdmins group.
Added SQLAdmins as a windows login on my local sqlserver instance.
Tried to login with my domain user but get "can't login..." message.
Is there something simple I'm not seeing?
thanks!
Hi,
we had a Problem that a colleague can't connect the SQL-Server on one server.
We use the VSTS 2005 and SQL Server 2005. He is trying to build a ne connection to the virtual maschine with his windows account and got the following message
Login Faild for User ''. The user is not associated with a trusted SQL Server connection.
He is user on the database and the server. he has dbowner rightson the database he tryed to connect.
How we can fix this Problem.
Thanks
Thomas
I read a lot of artical but didn;t find a solutio to this problem.
I have Windows 2003 SP1 install Reporting services 2005
I have other Windows 2003 SP1 server with SQL 2005 database.
I set kerberos delegetion control on the server in the AD
I also run the command
cscript adsutil.vbs set w3svc/1/root/NTAuthenticationProviders "Negotiate,NTLM"
on reporting services server but still getting this error message.
Any help ????
w3wp!processing!7!8/30/2006-00:00:01:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'MyDB'., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'MyDB'. ---> System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.
im creating a database for a product catalog. im using xp pro. im trying toc create a new database. heres my problem.
1. theres a red x next to the cylinder of the server (in visual studio.net ) is this a problem? how do i fix it?
2. when i try to connect to the sql server i get this error [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
3. what code do you i use to add a user and in what file, so i can connect to the server and create this database, once I can do that, I can develop the rest of this e-commerce site. Thanks so much!!
Tried using webmatrix code builder to simply bind a web grid to a sql table.
Works great in WEbMatrix, but when I move the code to Visual Studio.VB,
I get a logon error when the code is run.
Any Help is Greatly Appreciated... I am stuck.....
Here is the code:
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
DataGrid1.DataSource = GetCustomers()
DataGrid1.DataBind()
End Sub
Private Function GetCustomers() As System.Data.SqlClient.SqlDataReader
Dim connectionString As String = "server='localhost'; trusted_connection=true; Database='ASPExamples'"
Dim sqlConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connectionString)
Dim queryString As String = "SELECT [Customers].* FROM [Customers]"
Dim sqlCommand As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(queryString, sqlConnection)
sqlConnection.Open()
Dim dataReader As System.Data.SqlClient.SqlDataReader = sqlCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
Return dataReader
End Function
End Class
Hi All,
I'm using iis 4.0 with nt security to validate users. I'm trying to only pass the nt logon to sql and use
it as a filter when selecting records. I'm looking in the odbc driver and striking out there. What
variable is the logon assigned to so that I can construct it in the sql query???? How is this
done???
Direct email would be great!
Thanks
Mike
mgetlik@notes.cc.bellcore.com
HiOracle 8.1.7.4Hp Unix 11Application run peoplesoftLogon_time from v$session shows Friday Jan 3.The database was haltedon Saturday Jan 4.What is logon_time supposed to represent.All inquiries so far does notindicateThanks for your inputVincento
View 2 Replies View RelatedMy company is apparently performing some sort of security test on our SQL Servers by sending malformed packets to it, which results in SQL Server throwing a Severity 20 error and resulting in my butt being paged every night at around 3 AM. As you can imagine, this ticks me off, but they refuse to stop this test. The [edited] error text from the SQL Log is as follows:
Source Logon
Message
Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the client library. [CLIENT: 1.2.3.4]
Source Logon
Message
Error: 17836, Severity: 20, State: 1.
Is there a way to completely block a specific IP from attaching to SQL Server? Someone please let me have a complete night's sleep!
Brandon
Hi,
I am writing a web application in c# that is attempting to get the parameters from a report on a Reporting Services 2005 server.
I am using the following code:
SQLReportViewer.ServerReport.ReportServerCredentials = new ReportCredentials(UserName, UserPassword, UserDomain); SQLReportViewer.ServerReport.ReportPath = Rpt.FileName; SQLReportViewer.ServerReport.ReportServerUrl = new Uri(ServerUrl); Parameters = SQLReportViewer.ServerReport.GetParameters();
The Getparameters Line causes the following exception:
Microsoft.Reporting.WebForms.ReportServerException was unhandled by user code Message="Logon failed. (rsLogonFailed)" Source="Microsoft.ReportViewer.WebForms" ErrorCode="rsLogonFailed" StackTrace: at Microsoft.Reporting.WebForms.ServerReport.get_Service() at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() at Microsoft.Reporting.WebForms.ServerReport.GetParameters()
The UserName, UserPassword and UserDomain variables are all populated with correct data, as is Rpt.FileName.
The ReportCredentials class is a very simple implementation of the ICredentials interface - Code shown here:
-->
public class ReportCredentials : IReportServerCredentials { protected string _UserName, _Password, _Domain; public ReportCredentials(string UserName, string Password, string Domain) { _UserName = UserName; _Password = Password; _Domain = Domain; } //***************************************************************** public bool GetFormsCredentials (out System.Net.Cookie AuthCookie, out string UserName, out string Password, out string Authority) { UserName = _UserName; Password = _Password; Authority = _Domain; AuthCookie = null; return (true); } //***************************************************************** public System.Security.Principal.WindowsIdentity ImpersonationUser { get { return (null); } } //***************************************************************** public ICredentials NetworkCredentials { get{ return (new NetworkCredential(_UserName, _Password, _Domain)); } }
<--
I can use the same credentials to retrieve a list of reports from the report server (the report I am trying to access is in that list) and to log on directly by going to the URL of Reporting Services.
This is made more frustrating by the complete lack of detail in the error message, as it does not say why the logon failed, or give me a single clue about what is going on.
Has anyone seen this before and can tell me how to fix it, or is there something stupid in my code?
Thankyou.
Paul
Hi there!
Well this problem it's really driving me nuts!!!
I am using a CrystalReportViewer on a windows application which has an embedded report document...
The report (and the application too) is connected to an SQL Express server which is installed on an MS Small Bussines Server.
The server and the terminal PCs are under the same domain.
The app works flawlessly on the terminals, but when I open the form which contains the report I get prompted for logon to the SQL.. I have tried everything but it refuses to connect and i get a msg box : Logon failed.Please try again.
The sql surface area and the database have been configured to accept remote connections and mixed mode authentication (otherwise my app dosen't run at all), i have created sysadmin users(on the SQL), i have turned off the firewall but it is still refuses to connect.
I would like to mention that I have tested my app on my domain and SBS (I am not sure which version of SQL Server is installed) and I have used the develpment machine for the test. The logon is successful, even with the same account which the application connects (i mean the account included in the connection string)
Any ideas????
I appreciate your time,
thank you very much in advance...
Hi.
View 11 Replies View RelatedSQL Server 2005 SP2 add LOGON TRIGGER feature,
but, if logon trigger have bug, it seems that anyone can connect to the sql server.
for example:
create trigger tr_logon1_bug
to all server
for logon
as
insert into t1 values(original_name(), getdate());
and, drop table 't1'.
the result, everyone fail to logon, even if sa. (may be..)
therefore, cannot disable/drop this trigger ...
So, Are there anyway to disable logon trigger,
or to connect by sa/Admin,
when logon trigger failed.
Regards,
I have a report server that I restore from a copy of a backup from another SQL server on a daily basis. The problem is that the SQL logon in the report server does not work with the copy and I need to delete the logon in the database and reset the permissions for the SQL logon in order for the reports to run.
1. How do I enable the SQL logon to work automatically with the daily copy?
Thanks.
Dan
I have some production boxes on Win 2000 32-bits OS and some production servers have been upgraded to Win2003 64-bit OS runing SQL Server 2005. There are also a number of Win2003 32-bit OS running SQL 2005.
The issue is that when linking the 64-bit production servers to the 32-bit boxes running SQL 2005 / Win 2003 OS, the linking seems to succeed, but I am unable to see a number of entries in sys.objects. Typically, these objects are User Stored Procedures.
Moreover, the linking seemed to have worked, but data extraction does not take place between the servers. However, there are no errors. The objects (user stored procs) exist on the 64-bit side, but linking does not actually happen.
Microsoft KB has addressed this in SQL 2000 case in this KB article, but has not suggested a solution for SQL 2005.
Any ideas? Has anyone else encountered this?
Thanks.