wessamzeidan Posted September 16, 2004 Posted September 16, 2004 Hi, I just got SQL Server Reporting Services and I want to install it. The problem is that SQL Server is on one machine and visual studio along with IIS is on another machine. Is there that I can install reporting services such that the server tools are installed on sql server machine and the development tools are installed on vs.net machine???? Quote Proudly a Palestinian Microsoft ASP.NET MVP My Blog: wessamzeidan.net
wessamzeidan Posted September 17, 2004 Author Posted September 17, 2004 any one please Quote Proudly a Palestinian Microsoft ASP.NET MVP My Blog: wessamzeidan.net
Administrators PlausiblyDamp Posted September 17, 2004 Administrators Posted September 17, 2004 When you run the setup does it not give you the option of installing the designer / server portions? Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
wessamzeidan Posted September 17, 2004 Author Posted September 17, 2004 Yes, but when it comes to the screen where I have to type in the name of the server and the type of login, I get a strange error I type in the name of the computer that has sqlserver installed on it, and choose sql server login and type try to login using the 'sa' account which I usually use. I get an error telling me that user '<null>' cannot login to the sql server....... My question is, is it possible to install reporting services if sql server is on one computer and the vs.net and iis is on another? If so, why am I getting this error? Quote Proudly a Palestinian Microsoft ASP.NET MVP My Blog: wessamzeidan.net
Administrators PlausiblyDamp Posted September 17, 2004 Administrators Posted September 17, 2004 that looks more like a security problem - does the SQL server have sql authentication enabled? If so could you try using windows authentication to see if that makes a difference. Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
wessamzeidan Posted September 17, 2004 Author Posted September 17, 2004 sql authentication is enabled, this is how I login to sql server. Quote Proudly a Palestinian Microsoft ASP.NET MVP My Blog: wessamzeidan.net
Administrators PlausiblyDamp Posted September 17, 2004 Administrators Posted September 17, 2004 Does the server have mixed mode authentication enabled? If not then sa will not be enabled. If you normally use windows authentication can you not also use windows authentication for this part of the install? Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
wessamzeidan Posted September 17, 2004 Author Posted September 17, 2004 I have mixed mode authentication enabled, I'm really getting a headache from this, I've been trying to install it for 3 days now.....hope I find a solution soon Quote Proudly a Palestinian Microsoft ASP.NET MVP My Blog: wessamzeidan.net
Administrators PlausiblyDamp Posted September 17, 2004 Administrators Posted September 17, 2004 Is this failing at the point where you have to specify how the ReportServer service connects to the database? If so could you not just create a valid login for the service account and give it permissions? Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
wessamzeidan Posted September 17, 2004 Author Posted September 17, 2004 This is what I did, I created a new login and used it, but its still telling me that user '<null>' has no permissions to login to sql server... Quote Proudly a Palestinian Microsoft ASP.NET MVP My Blog: wessamzeidan.net
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.