User Prompts

Nov 13, 2006

Hi guys

I have been asked to develop a query which when run will prompt the user to enter the number of months before runnin the query.

I know we can do this in MS Acess .

can we do the similar sort of thing in SQL as well??

My query is

SELECT DHBMappingTable.[DHB Name], Agency.DHB_service, PurchaseUnitMappingTable.PU, PurchaseUnitMappingTable.PU_name,

SUM([NMDS Data for IDF Report].[Number of caseweighted discharges]) AS Expr1, AVG(wies2.[0607_cwd_WIES11]) AS Expr2,

AdmissionMappingTable.Admission, wies2.Admission_type

FROM DomicileCodes



In the above query, I need to multiply "0607_cwd_WIES11" with the no. of months



Lets say if the user is being prompted to enter the no of months and he enters 3, then "0607_cwd_WIES11" should be multiplied by 3 and divided by 12.

Do i have to use stored procedures(which I have got no knowledge of)

What do I have to do??

Pls help



Thanks

Mita

View 5 Replies


ADVERTISEMENT

Cascading Prompts

Jun 30, 2005

This question is for Bill directly. Hi Bill, I have lots of experience with RS, implementing the beta in a production environment, I was so impressed. Currently my company uses Cognos for financial reporting, and I am hoping to replace this with RS and MSAS. I have little knowledge of MDX, so I have been using your various series of articles to get up to speed. However, I don't get the article Mastering OLAP Reporting: Cascading Prompts. I fully understand how to build the prompts, but there seems to be a step missing in the article. You never replace the hardcoded where clause in the base dataset, and I can't seem to work out how to pass the parameter from the cascading prompts to the report. Maybe I'm being stupid, but the article doesn't seem to tell us how to do that.

Many Thanks

Sam

View 3 Replies View Related

Prompts In Model Designer

Oct 19, 2006

I would like to set up a prompt / filter as part of the model that carries through to the report builder. I have a query where I would like to force a prompt on the user as part of any report they create. Ideally, I would like to have it default as well.

I noticed that there is a prompt attribute in model designer. When I go to add the filter attribute in model designer, I get the same dialog box I get in the report builder - except it does not have the prompt as an option. Is there a way to accomplish this?

Thanks

View 3 Replies View Related

Hiding Parameter Prompts

Jan 24, 2008

Hello everyone,

I have a request to hide certain parameters in a report based on the current user logged into our web based report viewer using the ReportViewer control fo asp.net.

I am doing the standard stuff required to display the report as shown below.




Code Snippet
rptViewer.ServerReport.ReportServerUrl = new Uri("http://172.17.144.26/ReportServer"); // new Uri(MINETSecurity.WebSettings.WebServerPath, UriKind.Absolute);
rptViewer.ServerReport.ReportPath = ReportName;
rptViewer.ServerReport.DisplayName = "Report1";
rptViewer.ServerReport.ReportServerCredentials = new CustomReportCredentials("myUsername", "myPassword", "myDomain");






Now that i have loaded the report into the viewer i illiterate through the report parameters looking for the ones which the specified user should not see as show below.




Code Snippet
ReportParameterInfoCollection MyReportParams = rptViewer.ServerReport.GetParameters();
foreach (ReportParameterInfo MyParameter in MyReportParams)
{
// returns a value from a custom class which is a predefined value for this user based on the current user logged into the website
string Value = CustomParameterValues.ToString(GlobalUserSettings.CurrentUser.CustomValueList);
if(Value != "") MyParameter.PromptUser = false;
}



Here is where the promblem lies, when i try to set the value of PromptUser i get the following compiler error.

Property or indexer 'Microsoft.Reporting.WebForms.ReportParameterInfo.PromptUser' cannot be assigned to -- its is read only

Is there anything i can do to set certain parameters invisible to the user and set there value myself. I know i could create 2 seperate reports and set the PromptUser value in the designer but i dont really want to be duplicating reports just to hide or show parameters.

I have tried using the SetParameters method of the ReportViewer component to pass the value of the parameters that should be hidden and even set the visible property to false, but it dosn't seem to work.

Any help here would be appreciated.

Cheers
Scott Blood

View 8 Replies View Related

Use Parameters/Prompts In Calculates Fields

May 22, 2008



Hello,

We want to have one prompt (parameter) to set a point in time, so we can use this parameter as filter in other elements.
e.g. We have a point in time prompt, that we can set and use to filter by examples illness records and availability record (by the same (one) prompt)

View 9 Replies View Related

Database Prompts In SSRS Cannot Be Deselected

Oct 15, 2007



Hi,

Suppose I have two prompts, say A and B.
These two prompts are populated by using database queries.
B is dependent on A.
These prompts are multiselect.

I have noticed that it is not possible to deselect them once a value(s) are selected.
If I deselect all in A. They automatically get selected again.

They work fine as long as some value selected.
It is possible however to deselect all in B.

Thanks in advance.



View 6 Replies View Related

Create SQL Server Objects From Command Prompts

Jan 15, 2005

Hi

Is there any why to Create SQL Server Objects from Command Prompts like (Databases , Tables, Stored Procedures, …) ??

If you will Install some Applications Like this forums you will see the SQL Server object Created from Command Prompts

How Can I do that .. ??

And thanks with my regarding

Fraas

View 1 Replies View Related

Internet Explorer Prompts For Password After 300 Seconds

Jan 5, 2008



I am running a report which takes a long time to render. It has 500K rows in it that need to be summed and grouped. After 5 minutes IE prompts for a password. I set the report time out to 15 min just to see if it would make a difference. I even set the IIS timeout to an to 15 min as well.

I know that its bad to run a report this big, but I'm just curious why it prompts for a password. In case a user runs the report. Report uses dates so its possible they could go way back and not realize its 500K rows. I am assuming it is an IE issue with the browser and found a registry edit, but I don't really want to edit registries on my users' computers.

View 1 Replies View Related

Problem For The Prompts Will Display At The Top Of The Report In The Browser

Sep 27, 2007

hye everyone,
i have Problem for the prompts will display at the top of the report in the browser :






1)go to the report manager on computer and set the
set the Prompt User check boxes to checked.
--> auto check





2)select the report viewer control, if you are using it, and set the Parameters property to false.
--> the eror mesage will be display
" The ' field " parameter is missing value. "



what should i do...any idea
thanks in advance
thank you very much

View 1 Replies View Related

Retrun All Rows On Any Table From EM Prompts For Username/Password .. Why ?

Sep 16, 2004

Hello -

I dont know something weired happened on our MSSQL server today. We are able to connect to any Databases from Enterprise Manager from a Remote server.

Once we logged in and connected to a database on my database server, it keep prompting for the user id and password as we browsing through different tables in that database?

(Right click on the table then select Open Table -> Return all rows -> and it prompts for password )

Now when we enter password the contents of Table are displayed and now when we try to see contents of another table in the database it again prompts for password.


Any Idea whats wrong? How this can be resolved as it was not happening before .. :(

View 1 Replies View Related

Reporting Services :: Adding Values To Parameters In Dropdown Prompts In Reports In BIDS Or Report Builder

Nov 20, 2015

I run these stored procedure to build the report and I am able successfully to build the report but I need some prompts to in the report to get the specific data .

ALTER
PROCEDURE [dbo].[Sharepoint_Ticket_Report]
@StartDate
DATETIME,
@EndDate

[Code] ....

And for prompts how to create created_by and message_type dropdowns as shown in picture.

View 7 Replies View Related

Failed To Generate A User Instance Of SQL Server Due To Failure In Retrieving The User's Local Application Data Path. Please Make Sure The User Has A Local User Profile On The Computer. The Connection Will Be Closed

Dec 7, 2006

This is my first time to deploy an asp.net2 web site. Everything is working fine on my local computer but when i published the web site on a remote computer i get the error "Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed" (only in pages that try to access the database)
Help pleaseee

View 3 Replies View Related

How Do We Determine Which User Database Tables Are Mostly Retrieved By User Or Modified By User?

May 22, 2008



Hi,
Please give the T-SQL script for this ? Thanks

Shanth


View 4 Replies View Related

Generating User Instances In Sql Server Is Disabled. Use Sp_configure User Instances Enabled To Generate User Instances.

Sep 28, 2007

 When I am in Visual Studio 2005, and I try to add an SQL database, I get the following error "generating user instances in sql server is disabled. use sp_configure user instances enabled to generate user instances." I am currently using SQL server 2005 Express. What do I need to do, to create an SQL database? Thanks in advance. 

View 4 Replies View Related

Error : Cannot Open User Default Database. Login Failed. Login Failed For User 'server/user'

Nov 22, 2007



i'm using the Enterpirse library logger to write logs into a database.
When choosing connection string i choose the database i want in the "connection properties" dialog box and
push 'Test connection' button.
everything goes well.

then i open the SQL Server Management studio express and connect to the databse to check some things,
from that point on , when i push the 'Test Connection' button in the Enterprise library i get the error:


"cannot open user default database. Login failed. login failed for user My'server/MyuserName'"


even when i close the sql server manager , it is still stuck - the connection test doesn't work anymore....
it only work when i restart the computer.

why ?

View 3 Replies View Related

Cannot Open User Default Database. Login Failed For User 'NT AUTHORITYNETWORK SERVICE'

Mar 3, 2008

 Cannot open user default database. Login failed.Login failed for user
'NT AUTHORITYNETWORK SERVICE'. 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: Cannot open user default database. Login
failed.Login failed for user 'NT AUTHORITYNETWORK SERVICE'.  I have This Error When i try to log into My online web site, i have no idea how to fix it,one day it was working and the next it wasnt, is there any way to find out what database the default is and if it's either incorrect or not present change the web.config in a way that will make my system work. i have the NT Authority/Network Service in my Server Properties Permissions, its given the type login and is granted Connect SQL by sa i have 3 colder copies of the web site on my server my question is, how would i use of of these to restore the original site configuration is there a way to restore the original configuration to undo whatever it is i've done to break the system ChrisStressed 

View 3 Replies View Related

SQL Server 2012 :: Query To Find User Who Last Modified User Roles / Access?

Dec 6, 2013

I would like to know if there is a way to find out who changed a users roles/access WITHOUT using the audit function. For example, if a user account was created and given SA access then changed to read only, how can I find out who made that change? I tried searching for an answer, but kept getting no results. I'm thinking this may tie into the sys.sysusers view?

View 3 Replies View Related

[JavaScript Error] Cannot Delete User Or User's Authority In Specific Report After Install SQL SP2

Jan 23, 2007

 Hi,

I have several reports for users to view on our Intranet. After installation of SQL 2005 SP2 patch, I cannot delete user or user's authority from Report in Properties Tab. An error message was shown on the status bar. It indicated that JavaScript Error: 'Return' statement outside of function. Seems something wrong with the 'Delete' funciton in SQL 2005 after update. The other functions worked fine. Could you point me out how to fix it or need to install any updates / hotfix. Thanks a lot!

Regards,

Kenneth Lai
Programmer


Error Pic


Message Box

 

View 1 Replies View Related

Second User Trying To Connect Generates: Cannot Open User Default Database. Login Failed.

Apr 25, 2007

Hi, I'm new to SQL Express 2005.
I found information regarding : "Cannot open user default database. Login failed."on this forum but I think that in my case it's a bit different issue.
I have a website (ASP.NET 2.0) accessing DB, in the mean time Windows Service tries to update some data in the same DB (Service runs as NT AUTHORITYLOCAL SYSTEM). The second connection is rejected: "Cannot open user default database. Login failed.Login failed for user ....".
Problem occurs only when both: service and website are running at the same time. So service and website are running without problems when they are connecting DB exclusively.
My connection string is:
"Data Source=.SQLEXPRESS;AttachDbFilename="|DataDirectory|spider-lab.mdf";Integrated Security=True;User Instance=True"

I would be grateful if you can help me

View 1 Replies View Related

Login Failed For User 'testuser'. The User Is Not Associated With A Trusted SQL Server Connection.

Aug 19, 2006

Hi,
I have a copy of VS2005 and i have installed the Microsoft SQL Server Developer Edition
I am trying to do my first connection using ASP.net (yay for me...) and it has failed...with this error..Login failed for user 'testuser'. The user is not associated with a trusted SQL Server connection.
 
can someone please point out why? yes i know that the error seems pretty straight forward but how do i fix it? like how do i make the user a trusted server connection? where do i do it? and what are the steps? the user is an administrator and by rights should have all access to everything....
 
connection string
 
SqlConnection MySQLConnection;              MySQLConnection = new SqlConnection("server=cmptrname\databsename;uid=testuser;password=password;database=mytest");
 
btw while your reading do you have any examples of opening a db with the connection string in the web.config file? because i get some error "connection string has not been initialised"  using the
system.Configuration.ConfigurationManager.AppSettings.Get
i though i would stick to the top code first before i tackled the web config error first....
 
Thanks heaps
 
 

View 10 Replies View Related

Login Failed For User 'NT AUTHORITYANONYMOUS LOGON' (but User.identity.name Is Correct)

May 1, 2007

I need help.  The security principal is the correct DomainUser, but the error message says I am not authenticated.
So here is my error Message:
Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. Me.User.Identity.Name=CompanyDomainRyan; System.Security.Principal.WindowsIdentity.GetCurrent=CompanyDomainRyan; HttpContext.Current.User.Identity.Name=CompanyRyan
Generated by:
Dim secPrinc As System.Security.Principal.WindowsIdentity = System.Security.Principal.WindowsIdentity.GetCurrent
Me.lblError.Text = ex.Message & vbCrLf & vbCrLf & "Me.User.Identity.Name=" & Me.User.Identity.Name & "; System.Security.Principal.WindowsIdentity.GetCurrent=" & secPrinc.Name & "; HttpContext.Current.User.Identity.Name=" & HttpContext.Current.User.Identity.Name
Here is the Connection String:
Private ConnString As String = "Server=10.144.162.111;Database=DNS;Trusted_Connection=True"
 
IIS has 4 websites hosted on it.  The parent level allows anonymous with windows auth off, but the website level has anonymous off with widnows auth and digest.
In IIS, is there a problem with having the parent level anonymous and website level windows auth?

View 1 Replies View Related

Error Login Failed For User ''. The User Is Not Associated With A Trusted SQL Server Connection.

Feb 18, 2008

All the research I found dealing with this problem is that the solution is to set SQLserver to mix mode.  I have SQL server already set to mix mode. I am not sure what else to do. Has anybody run into this problem?
my connection string: <connectionStrings>
<add name="ConnectionString" connectionString="Data Source= server name ;
Initial Catalog=FILESHAREDB.MDF;
Integrated Security=false;"providerName="System.Data.SqlClient"/>
</connectionStrings>
 
Server Error in '/SendItNow' Application.


 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 ''. The user is not associated with a trusted SQL Server connection.Source Error:



Line 41:
Line 42: 'open the connection and execute the stored procedure
Line 43: mConnection.Open()
Line 44: mResourceID = mCommand.ExecuteScalar()
Line 45: mConnection.Close()Source File: H:MIS DepartmentIntranetSendItNowApp_CodeDalResourceDB.vb    Line: 43 Stack Trace:



[SqlException (0x80131904): Login failed for user ''. The user is not associated with a trusted SQL Server connection.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800131
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +172
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +381
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +357
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
ResourceDB.SaveResource(String filename, String fromContactEmail, String toContactEmail, String message, Int32 ID) in H:MIS DepartmentIntranetSendItNowApp_CodeDalResourceDB.vb:43
Resource.SaveResource(String filename, String fromContactEmail, String toContactEmail, String message) in H:MIS DepartmentIntranetSendItNowApp_CodeBllResource.vb:31
ContentFiles_Default.ImageButton1_Click1(Object sender, ImageClickEventArgs e) in H:MIS DepartmentIntranetSendItNowContentFilesDefault.aspx.vb:33
System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +86
System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +115
System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746



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

View 2 Replies View Related

Login Failed For User 'test'. The User Is Not Associated With A Trusted SQL Server Connection.

Mar 18, 2008

Hi all,
I am new in asp.net. In my web.config file, I wrote the connection strings as below and then I got the above error. I already changed SQL server Authentication mode to "SQL server and Windows". Any idea? Thanks in advance.
<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data Source=xxx;Initial Catalog=mydb;User ID=test;Password=test;Persist Security Info=False;"
providerName="System.Data.SqlClient" />
</connectionStrings>

View 1 Replies View Related

Login Failed: Reason: User &#39;_&#39; Not Defined As A Valid User Of Trusted

Jan 26, 2000

Our server has integrated security setup, upon startup of the server,
we have a continuous flow of error msg:
Login Failed: Reason: User '_' not defined as a valid user of trusted
connection.
The timing of these messages only around 30 seconds apart
The only incident from Technet I can find is Q186314, but we don't have replication setup, anyone knows where I can look into ?
I recycle the server but didn't help.
I appreciate any help I can get ..
Thanks.

View 1 Replies View Related

SQL 2012 :: How To Grant A New User Same Direct Privilege To Tables As Existing User

Feb 18, 2014

I am relatively new to sql developer. There is a new user that just joined our organization. I am trying to grant him the same direct grants privilege to the tables that an existing user has. The existing user has a ton of direct table access privileges and it will take days if I had to do each grant one by one like: grant select,insert,delete,update on 'table name' to 'user id'. Is there a way of copying or inserting an existing user's privilege and granting it to a new user.

View 2 Replies View Related

SQL 2012 :: Moving SSIS Solution To Another User - Reset User Encryption Key

Oct 22, 2014

I have an SSIS package built by another developer, and now that I'm running it under my login the passwords won't save. The solution and packages are setup with ProtectionLevel EncryptSensitiveWithUserKey, but how do I get the User Key to reset so I can now save passwords? I can re-enter them, but whenever I enter hte password and test it then click OK it still has the red arrow next to the connection as if there's an error. I can create new connections and those passwords save fine, but with 40-50 items in this package I hate the thought of having to go into each and change the connection.

I tried changing the package and solution to DontSaveSensitive then rebuilding and closing then reopening, I hoped there was some option to reset the User Key just as if I created the solution. If this option doesn't exist why?

View 1 Replies View Related

Help:SQLExpress User Instance Fails For Normal User; Works For Administrator

Jan 22, 2008

I'm using the RTM version of Visual Studion 2008 and SQLServer Express.

Logged in as an administrator, I can create a connection to an mdf file and all is well.

As a normal user, attempting to create a connection gives the message "sqlservr.exe has stopped working A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available."

I have tried this with UAC turned on and turned off. The result is the same. In Services I can see that SQLEXPRESS is running, but each time I try to connect, I get the "stopped working" message.

For existing database programs that have the .mdf file stored in the project folder, I can run the program in the VS IDE on my XP machine and on my Vista machine as administrator, but not as a normal user.

I'm not looking for a workaround to make this work once, but the cause and solution to the problem. This is for an introductory VB textbook and we must be able to move a database program from one machine to another and make it work. Everything I have read says that SQLExpress should be able to do that.

Can anyone help me with this?

Judy Fraser

View 26 Replies View Related

Login Failed For User 'KOQuotes'. The User Is Not Associated With A Trusted SQL Server Connection.

Apr 28, 2008



I cant find a reason why its doing this




Code Snippet
Login failed for user 'KOQuotes'. The user is not associated with a trusted SQL Server connection.

View 4 Replies View Related

Migration Problems From SQL 2000 To SQL 2005: User Cannot Find The User 'RSExecRole'

Jan 25, 2008



Hello,



I am trying to migrate reporting services from SQL server 2000 to SQL 2005. I followed the migration steps listed in one of the TechNet documents. Installed SQL 2005 and SP2.

Backed up existing SQL 2000 databases and restored on SQL 2005.

Went to Configuration tool and then to the Database setup. Connected to SQL 2005.

Clicked on the Upgrade button. The upgrade fails and I always get the following errors:

"The database version (C.0.6.54) does not match your reporting services installation. You must upgrade your Reporting services database"

Then I get this exception:

System.Data.SqlClient.SqlException: Cannot find the user 'RSExecRole', because it does not exist or you do not have permission.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)



I do not understand why it is looking for user 'RSExecRole', which is a role.



Appreciate your help

View 3 Replies View Related

Login Failed For User 'KOQuotes'. The User Is Not Associated With A Trusted SQL Server Connection.

Apr 28, 2008



I cant find a reason why its doing this




Code Snippet
Login failed for user 'KOQuotes'. The user is not associated with a trusted SQL Server connection.

View 11 Replies View Related

DB Engine :: Extract All Privileges And User Password For A User In DDL Format For Server?

Jul 12, 2010

My goal is to write a DR plan where i am restoring all user databases onto a diffrent server in a event of hardware failure. I was trying to figure out a way to extract DDL of user accounts and their permissions on all user databases so i can simplify my DR documentation. 
 
This is the plan I came up with...to restore all system and user dbs on a different Physical SQLServer.

1. build named instance $PROD

2. restore master database

    - startup sqlserver in single user mode -m or DAC sqlcmd -S ServerName -U sa -P<xxx> –A
    net stop MSSQLSERVER$PROD
    net start MSSQLSERVER$PROD -m
    - restore database master from disk e:master.bak with replace;
   
3. start sqlserver normally

4. stop SQLServer agent

5. restore msdb

-restore database msdb disk e:msdb.bak with replace;

6. restart SQLServer

7. Restore User Databases.

8. Run Sp_change_users_login for all users

-Sp_Change_users_logins 'auto_fix','username'

View 7 Replies View Related

Is There A Way To Show A User-friendly Error When User Did Not Select A Required Parameter ?

Apr 9, 2007

Hi all,



I was wondering whether there is a way to show the user an error when the user did not select a specific parameter.



In my case, I have two optional parameters. The user has to select either one to view the report. If the user does not select either one, I would like to show some sort of an error page indicating so. However, all i am getting is a complete blank with no report in sight. I as a developer know this is an error as a result of missing parameters, but i was wondering whether I could produce a page or direct it to a page so that the user doesn't go all horrified at an empty page ?



Thanks

Bernard

View 4 Replies View Related

Login Failed For User 'username'. The User Is Not Associated With A Trusted SQL Server Connection.

May 9, 2008



Hi All,

We have setup a SCOM 2007 Server and in this we have SQL 2005 SP2, We are using two accounts one for OPRATIONAL DATABASE and another one for REPORTING DATABASE after this setup everything was working fine but suddenly my SDK account which is for REPROTING DATABASE was locked by entering wrong password and afterwards I unlocked the password but SINCE this i'm not able to connect to my REPORTING DATABASE and i'm getting following ERROR:- Login Failed for user 'username'. The user is not associated with a trusted SQL Server connection.

Taken following action to rectify this problem:
1) Resetting the SDK password with the same password.
2) Restarted all the SQL and SCOM services.
3) Restarted the Server as well.
4) Converted from WINDOWS AUTHENTICATION mode to MIXED mode.


But the problem is still persisting, Please help ASAP.

Regards,
Akhilesh

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved