I am using SQL Server 2005 developer edition and Visual Studio 2005. I am working on local computer and when I define a cube I am using data sources to which I can connect without any problem using "Test connection". However, when I want to perform calculation or browse a cube I get a message of either I am as a user do not have permission to access source database (in reality I do have this permission) or source database does not exist (in reality it exists). I check the SQL Server Browse Service and it is not running and the option of starting it is disabled (Start mode is undefined and only properties option can be used). I already have enabled the TCP/IP and Named Pipes protocols but I still cannot browse cube data.
Any help SUPER welcome.
Elka
I have configured an instance to use static port, say 1435, and I turned off the Browser service.
I would like to know if I can use SSMSE to connect to the instance database directly. The instance is listening at port 1435 and accepting connection requests from other methods.
What I need to put into the "Server name: " field?
Normally, it would be like: <serverIP><InstanceID> with Browser turned on.
Now how do I add the port information to it, I tried
SQL Server Browser listens on a UDP port and accepts unauthenticated requests using SQL Server Resolution Protocol (SSRP). SQL Server Browser should be run in the security context of a low-privileged user to minimize exposure to a malicious attack. By default, SQL Server Browser starts using the Local System account. The logon account can be changed by using the Windows Services program. The minimum user rights for SQL Server Browser are as follows:
* Deny access to this computer from the network. * Deny logon locally. * Deny logon as a batch job. * Deny logon through Terminal Services. * Log on as a service. * Read and write the SQL Server registry keys related to network communication (ports and pipes).
In our case the SQL Server Browser service is running under the same Windows account as our other SQL Server services. Do you recommend creating a separate Windows account for the SQL Server Browser service as described above?
Can you help me understand how an attack can occur?
I recently setup mutliple instances of SQL Server Express at my office. I have 1 default instance, and two named instances. I can connect to the named instance of the default port of 1433 with Microsoft SQL Management Studio Express, however the other instances on dynamic TCP ports can not be accessed by the instance name over the internet. I have to specify the dynamic TCP port in this form: xxx.uconn.edu/SQLTEST, Port number. My current thinking is that the SQL Browser service should tell Management Studio Express what dynamic port number each SQL instance is listening to. Any ideas?
Please assist, the issue with SQL 2005 Browser and SQL 2000 Server Service is understood.
Our problem is with networked 2000 instances and SQL Express. The SQL 2000 machines (Standard & MSDE) do not have SQL 2005 or Express installed only 2000. When a SQL Express computer is put on the network with the SQL Browser service running almost all SQL 2000 machines lose sight of the other SQL 2000 instances. The second the SQL Browser is turned off on the SQL Express box the SQL 2000 machines can see each others instances. It appears that the response from the SQL Express SQL Browser causes the SQL 2000 machine to stop listening for responses. Once in a while one of the SQL 2000 instances will show up with the SQL Browser active on the network and it is my belief that it is because that response made it in before the SQL browser response. Please help as this does not appear to be a recognized issue. I'm assuming there aren't many sites running as many named instances on individual machines like we do.
Please note this appears to be a problem with SQL Express Browser not SQL 2005 Standard's which runs without problems on our network.
I have been trying to drill down to the cause for this event log message: "The configuration of the AdminConnectionTCP protocol in the SQL instance SQLEXPRESS is not valid." It is reported from the SQLBrowser service as a warning when the service starts. I have tried starting SQLBrowser.exe with -c flag, but the output reveals no errors. I have seen this error on three computers. Two are running SQL 2000, 2005 and Express. One was only running Express, but still this message. I then looked into the log for the SQL Express server itself. It shows this message on startup: "Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required." Now, it appears to me that these two messages may relate to the same "error" (or rather behaviour by design). So, can anyone confirm that the warning in the event log from the SQL Browser service occurs becuase of that the SQL Express edition doesn't allow any "AdminConnection", but the SQL Browser service isn't aware of that SQL Express edition shouldn't support that, and reports it as a warning (implying that we can't do much about this warning)?
I just installed SQL 2005 Express, and I do not see the SQL browser and the Administration tool anywhere in my computer. Does anyone know what I need to do?
Most of the times I cant see my database tables from the query analyser in the object browser window... There are some times that appear normally...but in mosto of cases they just dont appear at all...I can only see the master database and msdb... I am connecting giving the proper password...
bear in mind that I can write and execute queries to my database although I cant see the tables
Why could this be happened??? Is a matter that i have discussed with my hosting provider or I am missing something here???
Hi!I'm trying to build an app. for my parents' office. They have a smalloffice (5 PCs), and they currently work with a very old program that'sbased on DOS. The program doesn't work well under XP, so they still useWin 98. They had their network upgraded about a year ago. They hadMicrosoft SBS 2000 installed, it includes SQL Server. I've written afew DB's in Access before, and now I'm just learning how to use SQL.Before I start work on their app., I have a question:I know it's possible to create an interface that can be put on theirnetwork and accessed via a browser. How is this done exactly?It would be very beneficial for me, because it would mean that the newapp. would be platform independent, so that they can upgrade to XPeasily. It would also save us the cost of licensing front-end software(e.g. Access) for each machine.Any comments would be appreciated.Noam Nelke, Israel.
I have noticed a change in how the new version Internet Explorer renders.
I have a couple of simple matrix reports with textbox buttons that use a drill through to the same report with the reportdate parameter being incremented or decremented by one day.
The report cells calc font and color based on data, nothing to elaborate. In IE 6 the report was displayed quickly. When I upgraded to IE 7 the same report's performance has degraded greatly. In IE 7 the data is returned in the same time frame as before and the report is rendered quickly then my CPU pegs out to 95% for about 5 seconds making it seem as though the browser has locked up. It doesn€™t matter if I have 5 rows or 500 rows.
This is happening to all my reports with jump to report functionality but only if the report to jump too is the same report with different parameters.
Hello there, We have a Windows Server 2003 where SQL Server 2005 is installed. The problem is that SQL Server browser cannot be started. When I try to connect to any instance of SQL Server, the connection fails. I have to try to start SQL Server browser and try to connect again to the particular instance of SQL Server after each attempt to start the browser. I succeed after several such attempts to connect, but SQL Server browser will still not start. Can anyone tell me what can be wrong with SQL Server browser? Thanks in advance Hemant
I think it whould be simpler to explain what I am trying to accomplish. I wish to pull a query to return multiple records from a SQL 7.0 database. The query is a customers standing order. I wish to make edits to multiple records then return those records for update. The HTML pages that I have seen all seem to display tables on a singular record format. Is it possible to display records in a 'Table' format and allow it to be updated. Can any one answer this or direct me to a site with the relevent info. Thanks Stuart Indtec@eircom.net
Does SQL Server have a session browser similar to Oracle and if so, how can I use it? I am looking to retrieve the SQL being ran when users are running particular reports from a gui tool.
Hi, I have created a sample report called Report1 in SSRS 2005. This currently is running locally on my workstation. I can even browse to it using the http address i.e. http://localhost/Reports The question is: How can someone else access this report on my machine. They can not browse to my machine by typing http://12.32.2.344/Reports
Do I need to do any configuration in my local IIS? Thanks
hi! As a newbie quite confused.. Created mesures in my cube which are not working. When I run MDX select-commands in Management studio they do not show any measure calculations(Total sum), just NULL, but the headers are there, as the Month.
The same in Browser: Headers showing but not Measure calculations. They are empthy. How could I solve this?
We have a 6 node cluster with 4 SQL Server named instances in the cluster. I am noticing a lot of warnings in the event log with the following information: Event Type: Warning Event Source: SQLBrowser Event Category: None Event ID: 3 Description: The configuration of the AdminConnectionTCP protocol in the SQL instance <instance name> is not valid. The event occurs for all four instances. Additional Information: * OS is Windows 2003 R2 Enterprise x64 Edition w/SP2 * SQL Server 2005 Enterprise Edition w/SP1, hot fix level 2221 * All SQL services runs under the same domain user account
I did some internet searches and found several others who have had this problem. However, I didn't see any solutions. There also seems to be a similar problem with SQL Express but that is not what I am using.
I am using sql express w/ advanced services on xp pro with IIS 5.1 installed. On the local machine named 'Tester' i am able to access reportserver using a web browser and the url: http://localhost/reportserver. But when i go to another machine on the same network and domain and try to access the reportserver with url: http://Tester.domain/reportserver or http://<ip address of Tester>/reportserver ie tells me page cannot be found and does not give me any errors. How do I set up network access to reportserver on the machine Tester? Help would be greaty appreciated.
Currently I am being told that for someone to remotely view reports that are stored in RS an individual needs to login to a PC's OS with the correct domain and user name. When they launch the browser it will them allow them access to the reports stored in RS.
This seems to limit the capabilities for a remote access
Can you go to any PC anwhere, type in the URL, and get a prompt for user name and password for access? Will the user name and password allow restrictions to what you can see? Is there anwhere where I can see an example of this? Like a dummy site or something?
I installed SQL Server 2008 Express lastnight, and the server is running but I am unable to get Server Broswer, or Server Agent to start, when either is tried I get the following error:WMI Provider error.The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.
i installed two servers, one instance SERVER05 and second SQL SERVER EXPRESS called SQLEXPRESS.
my SQL Server Browser service is in state "Change Pending" i dont know if it is ok?
I setup SERVER05: TCP/IP in Conf Manager Enabled, listen all yes, and IPAll TCP Dyn. ports nothing = blank, TCP PORT 2001 i think that SERVER05 is listening on port 2001 now. i restart SERVER05 and try this command: SQLCMD -E -S MACHINEASERVER05,2001 connect successful
I want to do this with SQLEXPRESS i set TCP enabled, Listel all, Dyn port blank, TCP PORT 2002 restart and get error:
Unable to start service MSSQL$SQLEXPRESS on server MACHINEA Additional information The MSSQL$SQLEXPRESS service on MACHINEA started and then stopped. (ObjectExplorer)
I have some hyperlinks on different rows of a table in the report. Currently when I click on these, they open the links on the same page. I want the link to open in a new instance of IE.
I tried using "javascript:void(window.open('http://www.google.com','_blank'))" as the URL, but this will virtually do nothing.
I've installed the Developer's edition of SQL05 on my PC at home. I am able to open the reporting services via the Manager Studio and Windows login under my username and password, however I cannot open it in my browser when I enter the
http://computername/reports address. I get a login dialog and enter "computername/myloginID" for the user and my local login password. It will not accept the login and reprompt until I exceed 3 tries.
I also tried logging in with the PC's admin id and password as well as the sa account name and password.
Any ideas on what I missed in the setup or security?
I'm having an issue where I print a reporting services report through a browser be it IE or Firefox and the report page is being split into two pages for a single page. A report that is 3 pages ends up being six pages when printed. Does anyone know of a fix or workaround for this problem.
I use SQL Server 2005 for multi-user access. In the Surface Area Configuration, I changed the protocol from TCP/IP to Named Pipes and restarted the service. Then I went to SQL Server Browser, stopped it and clicked on Start to restart. I am getting a message "An error occurred while performing this operation". I am not able to get the Browser started.
Hi, I have deployed my report to the report server and send a link to the users to view the report on the browser. But when the report is viewed, it shows up as "restore down" instead of "full screen". For example, the report shows up in the browser with all the information below.
SQL Server Reporting Services
Home > school > hwal> test > Proficient By Ethnic within School and Grade Rdg and Math
How do I set up the report to make it show up as full screen report without all the details above?
Hi all, newbie here (to SQL Server and Visual Studio)... After a few days of configuring and setting things up, I finally got visual studio 2005 to connect to my sql server 2005 express database. I used server management studio to construct a database with 8 linked tables for my first main application. I plugged in some data and, after setting up proper permissions, was able to get visual studio to connect and return data. I set up a simple gridview on a page with a sql server connection object to test things out. When I set the connection string to return data from a single table, everything works fine. When I test the connnection within visual studio, I get the results I expect. I build the page and load it up in my browser through the localhost, and I get the expected results. The problem comes when I try to use a view rather than a table. I build the view in server management studio, and from within visual studio, when I test the connection I get the expected results. However, after building the pages (and rebuilding the site), I get a blank grid in my broswer when I test through localhost. I added another gridview to the page set to a table with a different connection string, and that grid appeared in my browser. I modified that connection string in visual studio to the sql server view, and again, nothing appears in my browser. I'm not sure if, during all of my tinkering with security and setups I may have inadvertantly shut off the abilty to use views, but I'm not receiving an error messages. I just get a blank page. Any ideas?Brian
