.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Problem with Permissions on SQL 2005

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
 
I don't even know if my title is a fair explanation of my problem, sorry if it isn't. We are on a network using AD, probably a very typical scheme. My SQL Server is 2005 on a Server 2008 Enterprise machine. My boss had written for him a VBS which will prompt the user for the server name, then Database name and the upload a specific CVS into the proper SQL tables. As a user who is a member of the AD Administrator group, I can run the script no problems. However  the person who needs to run this script on a regular basis gets an error in a "Windows Script Host" dialog box. The error is "Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user 'CC\maurice'." I thought it may be how the SQL drivers are setup on his machine, but when I log in through his computer, I can run the script fine. Is this a setting my SQL server, or is it actually an AD issue I am dealing with?   Thanks for reading.


View Complete Post


More Related Resource Links

Problem when installing Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint

  
Hi,

I have configured the SharePoint Production Server(Standalone) with WS 2008 64 bit version, SQL Server 2005 with SP3 , Visual Studio 2008 and MOSS 2007(SP3). I have configured SSRS 2005 in SharePoint integration mode. Everything works fine till the last step. Now, i am trying to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies feature and failed. I am getting below error message.

Product: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies -- You must first install SharePoint Server before installing SQL Server 2005 Reporting Services Add-in for SharePoint Technologies



Any help will be very appreciated!

Thanks,
-Raj

Report printing problem(ssrs 2005)

  
HI   i have a SSRS 2005 report with width as 32 inches i have a requirement to print the report in a3 landscape  but when i print the report it comes in 3 page width   is there any way to auto scale the report into a3 size without affecting the view in the report viewer   Thanks varun kumar

SQL 2005 Database Problem

  
When trying open up a report from a customer database.  I recieved the following error: Please contact technical support with the following information:   Error ID: ERHIG030000340 Error message: There was a problem with the SQL or table when trying to open the display The table name is "taOrderHistory" The SQL is: Underlying problem: Column 'taOrderHistory.OrderHistoryID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at RadWebNet.rwDataSupport.OpenData(String SQLIn, rwConnection ConnIn, OpenDSReturnType ReturnWhat, Int32 TimeOut, Object[] ParamsIn) in D:\Misc Projects\RadWeb\RadwebV4-7-1\rwData.v

Problem to install MS SQL 2005 on Window 7 Operating System

  
Hi, I recently have problem to install MS SQL 2005 on Window 7 Operating System. Setup showing an error for compitability issues. When click on to button to check for solution online, after a while it pop up that No solutions found for Microsoft SQL Server 2005. Any one know solution for this? Is is possible to install Microsoft SQL Server 2008 on Window 7 and migrate data from Microsoft SQL Server 2005 to 2008? Please advice. Appreciate your help. Thanks.

Problem Integration SQL Reporting Service 2005 and SharePoint 2007

  
Hello, I'm trying to make our SQL Reports available on our SharePoint report center. I have SQL 2005 (sp3) report server that resides on a different server than our SharePoint 2007 server. So in our SRS Configuration Tool, we changed the database mode for SharePoint integration (before, we only had it in native mode), so we created a new database for this SharePoint Integration type. Next, I installed the Report Server Add-in for SharePoint 2007 server and it was successful. However when configuring the Report Server, we got stuck at the step "Grant Database Access". For some reason we keep getting error message "Named instance not found" We already installed Service Pack 3 on the Report Server... I heard that the problem is because the mismatched version between the Report Server Add-in in SharePoint and the SQL RS version... but I don't think this is the case for us. Do we need to install WSS on our Report Server too?     Another question: We already integrate our Report Server with Microsoft Dynamics CRM 4.0. However I see that when the Report Server is in the SharePoint Integration mode, all the reports in CRM don't work (because Report Manager is no longer available in this mode). Do you think it would be the best practice to install a copy of Report Server instance in our SharePoint 2007 server? Thank you, greatly appreciate all your hel

Problem Integration SQL Reporting Service 2005 and SharePoint 2007

  
Hello, I'm trying to make our SQL Reports available on our SharePoint report center. I have SQL 2005 (sp3) report server that resides on a different server than our SharePoint 2007 server. So in our SRS Configuration Tool, we changed the database mode for SharePoint integration (before, we only had it in native mode), so we created a new database for this SharePoint Integration type. Next, I installed the Report Server Add-in for SharePoint 2007 server and it was successful. However when configuring the Report Server, we got stuck at the step "Grant Database Access". For some reason we keep getting error message "Named instance not found" We already installed Service Pack 3 on the Report Server... I heard that the problem is because the mismatched version between the Report Server Add-in in SharePoint and the SQL RS version... but I don't think this is the case for us. Do we need to install WSS on our Report Server too?     Another question: We already integrate our Report Server with Microsoft Dynamics CRM 4.0. However I see that when the Report Server is in the SharePoint Integration mode, all the reports in CRM don't work (because Report Manager is no longer available in this mode). Do you think it would be the best practice to install a copy of Report Server instance in our SharePoint 2007 server? Thank you, greatly appreciate all your hel

SSIS 2005 - Send Mail Task - signature appended to email is garbled - unicode problem?

  
Hi, I'm pretty new to SSIS so go easy on me. I have a Send Mail Task to notify if a file cannot be imported - the mailbody is created on the previous step by a VB.NET script task to include the name of the file and the path it's been archived to. The problem I'm having is that while the body of the email I've created is displaying fine, our company's Exchange server appends a signature to all emails, and this is coming up as undisplayable characters, presumably due to some kind of unicode encoding problem. I've tried casting the email body in an expression to DT_STR (doesn't work as DT_STR "cannot be converted to a supported type" which seems a bit odd but never mind), DT_WSTR (garbled signature), DT_TEXT/DT_NTEXT (strange error on this one - "Attempted to read or write protected memory") none of those ideas worked, and I'm a bit stumped now. Can anyone help? I'm using SSIS 2005 with SP3

Export to CSV w/ grouping problem after 2005 upgrade

  
Hi,After upgrading to reporting services 2005 from 2000, reports that used to export to CSV correctly don't now. It appears the CSV export suddenly stops at a table with grouping. Any ideas would be appreciated...Thanks.

SQL Server 2005 Express Edition - GUI to set permissions on stored procedures

  
Hi there, I have SQL Serve 2005 Express Edition (Build 2600: Service Pack 3) installed; I also have the Management Console installed. My problem is that I cannot set execute permission, or any other type of permissions on my stored procedures through the GUI, as the Property menu item is missing from the right click menu. I read somewhere that this happens when you have SP1, but as I stated above I have got SP3 installed... Any help?   Regards, D.

problem with SQL 2005 enterprise

  
I setup SQL 2005 on my machine and when i open SQL 2005 mangment i don't know where i can get Server Name to connect it ... and after that i remove it and setup again and i note that there is non active component in setup like SQL Data Base .... so my questions are  1 - How can i know my server name ( i try to use my computer name and local and use windows auth. and sql authontication ). 2- I think the problem is that there is previous files so i need to totally remove SQL Server ?

Barchart migiration problem when I move it from SSRS 2005 to SSRS 2008

  
Hi I am having a barchart report in ssrs 2005 which  is going to dynamically generate the bars depending on the input parameters for example if we give 15 as input it is going  to generate 15 bar on the chart and if we give 25 as input it is going to generate 25 bars on the report.Report is working well in ssrs 2005 but when I migrate it from ssrs 2005 to ssrs 2008 and run the report it is working well when i select 15 as input it is showing me 15 bar with the names on x-axis and y-axis.But when I select 25 as input it is generating bar chart  and I see multiples of 5 like(5,10,15,20)  bars are getting the names displayed on the y-axis and rest of the names are not displayed on chart.I was trying to expand the bar chart  and trying to see the different.When I expand report is spliting into two pages and I see multiples of 5 like(5,10,15,20) bars are getting the names displayed and rest of the names are not displayed.So can anyone suggest me any solution.   Thanks in Advance

Database connectivity problem (sql server 2005)

  
I want to connect my database using my windows application. My database is on the server and i my connection string is something like that Data Source=123.45.67.89;User ID=myUserID;pwd=MyPwd;Initial Catalog=MyDatabase When i  try to connect in my local network using this connection string this work fine Data Source=MyServerName;User ID=myUserID;pwd=MyPwd;Initial Catalog=MyDatabase These are my server setting Go to "SQL server 2005 Surface Area Configuration" Surface Area Configuration for Services and Connections In Configure Surface Area for localhost (chnage computer) 1)Click (chnage computer) 2)Then Select Computer Window open, Now checked the local computer -> OK View By Instance: 1)Database Engine -> Service Start 2)Database Engine -> Remote Connections -> Local and remote connections -> Using both TCP/IP and named pipes 3)SQL server Browser - > Service Start Apply - OK View By Component: 1)Database Engine -> Service Start 2)Database Engine -> Remote Connections -> Local and remote connections -> Using both TCP/IP and named pipes 3)SQL server Browser - > Service Start Apply - OK Now In SQL server Configuration Manager. Shared Memory   : Enabled TCP/IP   : Enabled Named Pipes : Enabled VIA  : Disabled Select Client Protocols in the left side. In the TCP/IP Properties these are my

Problem with permissions

  
I've been running SSRS with an administrator account during development.  Now I am trying to deploy it for users.  I have a Domain group, SQL Users, that I've added to Report Manager.  I've given the group the following roles (same as the administrator account I use to run reports): Browser, Content Manager, My Reports, Publisher, Report Builder. When a SQL User tries to run a report they get:  An error has occurred during report processing. (rsProcessingAborted) Query execution failed for data set 'Division'. (rsErrorExecutingCommand) For more information... What permissions am I missing that is preventing the user from accessing data from the datacube?

Problem Installing SQL 2005 Enterprise on Server 2008R2 Enterprise???

  
I am trying to install SQL Server 2005 Enterprise onto a new WinServer Enterprise 2008R2 box.  I am using my MSDN disk that contains the various flavors of SQL Server 2005.  When I select to install Enterprise (64 bit) version all that is available for installation are the client tools, no server tools.  When I install the Standard version, the server tools are available. Is there a problem installing SQL 2005 Enterprise on WinServer Enterprise 2008R2???

problem in date format in sql 2005

  
I am new to sql2005  My problem is,  I send a date parameter (@fdt  and @Tdt)   like "DD/MM/YYYY" format through Sql reporting services My query is select  * from deposits where Depdate >= @fdt and Depdate <=  @tdt in the aove query there is no record has been fetched   But i give like this,  Inthis case i get a resultselect  * from deposits where Depdate >= '2010/04/01' and Depdate <= '2010/08/31' pls tell me how can i convert the date to "yyyy/mm/dd"    in where condition   Thanks Gk  

SQL 2005 Standard - problem with ORACLE replication

  

Hello All

Windows 2003 SP2  x64 + SQL 2005 Standard 32bit + Oracle ODBC Driver 10.2.01

Replication between SQL servers works FINE, bit I'm not able to replicate betwen MS SQL and ORACLE server.

Any ideas ?


Artur

Win Forms from VS 2005 to VS 2010 Problem....

  

Hello Experts,

                 I'm working with Win forms using Visual Studio 2005 and code behind language is Visual Basic.My current project contains more than 450 forms.We were planning to migrate it from VS 2005 to VS 2010.So, I opened  my project with VS 2010.It had changed from framework 2.0 to framework 4.0. It builds and runs fine.

My Problem is that,

After  running my application . When I open any form it gives me an Exception System.outofmemoryexception...

If I clean my project It works fine...

What will I do for it?????

I'm googling in the internet... I had found lots of article... But no one is works for me...

Thanks in Advance


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend