I HATE Management Studio, how about you?

I really dislike the Management Studio in SQL Server 2005. Having tabs
is nice but everything else about it really sucks. What don't you like
about it? Maybe someone at M$ will read this and actually make some
changes -- for the better (sigh, I wish but I won't hold my breath).

For all the $$$$$ Microsoft spends you think they could do better. It
seems every 'new and improved' version has a worse UI than the one
before. I can hardly stand to use Visio any more. Word has so many
damned annoying features that I spend most of time trying to figure out
how to turn them off rather than getting real work down.

Living in the shadow of the evil empire I run into M$ dweebs all the
time. One of the biggest problems M$ has is arrogance. They 'know
better' than the whole user community.

Microsoft get a clue. Trying listening once in a while.Hi JJ,

It would help if you actually list things you dislike instead of just
ranting it doesn't do very much for your credibility, you simply come across
as probably one of those anti-MS whatever they do people - aka the linux
fanbregade.

I agree there are aspects of Management Studio that I dislike but those are
being addressed by Microsoft and believe those guys do listen to what WE as
the people who use the tools and product need.

So, lets try again - please list aspects of MAnagement Studio you dislike.

--
Tony Rogerson
SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson - technical commentary from a SQL
Server Consultant
http://sqlserverfaq.com - free video tutorials

"jj" <jj@.no_spam.netwrote in message news:e8tt3n$fnl$1@.lists.fhcrc.org...

Quote:

Originally Posted by

>I really dislike the Management Studio in SQL Server 2005. Having tabs is
>nice but everything else about it really sucks. What don't you like about
>it? Maybe someone at M$ will read this and actually make some changes --
>for the better (sigh, I wish but I won't hold my breath).
>
For all the $$$$$ Microsoft spends you think they could do better. It
seems every 'new and improved' version has a worse UI than the one before.
I can hardly stand to use Visio any more. Word has so many damned annoying
features that I spend most of time trying to figure out how to turn them
off rather than getting real work down.
>
Living in the shadow of the evil empire I run into M$ dweebs all the time.
One of the biggest problems M$ has is arrogance. They 'know better' than
the whole user community.
>
Microsoft get a clue. Trying listening once in a while.
>
>
>

|||jj (jj@.no_spam.net) writes:

Quote:

Originally Posted by

I really dislike the Management Studio in SQL Server 2005. Having tabs
is nice but everything else about it really sucks. What don't you like
about it? Maybe someone at M$ will read this and actually make some
changes -- for the better (sigh, I wish but I won't hold my breath).
>
For all the $$$$$ Microsoft spends you think they could do better. It
seems every 'new and improved' version has a worse UI than the one
before. I can hardly stand to use Visio any more. Word has so many
damned annoying features that I spend most of time trying to figure out
how to turn them off rather than getting real work down.
>
Living in the shadow of the evil empire I run into M$ dweebs all the
time. One of the biggest problems M$ has is arrogance. They 'know
better' than the whole user community.
>
Microsoft get a clue. Trying listening once in a while.

Management Studio is definitely not the part of SQL 2005 that I am most
impressed by. There are some nice improvements from Query Analyzer, but
there are too many features that have been dropped from the old tools.

If you go http://connect.microsoft.com/feedba...aspx?SiteID=68
you can submit suggestions for improvements. Such suggestions would
have to be a little more nuanced than "get a clue" to be meaningful. :-)
I would also encourage you to search among the existing bugs. There
are already plenty of entries for Mgmt Studio filed. And fact is,
MS have been listening. It looks that some of the issues will be
mended by SP2 already.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||I like Management Studio. I've replaced the old Query Analyzer and
Enterprise Manager with this one. I used it for both SQL 2005 and SQL
2000; they are fine. Except one thing though; if I edit a table, the
default column has to be filled in; otherwise it will be filled with
NULL, eventhough the table is defined as NOT NULL DEFAULT something;

regards,
Radzi.

jj wrote:

Quote:

Originally Posted by

I really dislike the Management Studio in SQL Server 2005. Having tabs
is nice but everything else about it really sucks. What don't you like
about it? Maybe someone at M$ will read this and actually make some
changes -- for the better (sigh, I wish but I won't hold my breath).
>
For all the $$$$$ Microsoft spends you think they could do better. It
seems every 'new and improved' version has a worse UI than the one
before. I can hardly stand to use Visio any more. Word has so many
damned annoying features that I spend most of time trying to figure out
how to turn them off rather than getting real work down.
>
Living in the shadow of the evil empire I run into M$ dweebs all the
time. One of the biggest problems M$ has is arrogance. They 'know
better' than the whole user community.
>
Microsoft get a clue. Trying listening once in a while.

I dont see Server Management Studio on the XP with the Standard version

I have installed SQL 2005 Standard Edition on my Window XP many times and I dont see Server Management Studio.

Did I do something wrong?

Thanks.

you need to have Windows XP professional edition with SP2........refer the link,

http://support.microsoft.com/kb/910228 and if you have the necessary system requirements just go to tools folder and manually run the sqlrun_tools..........it will get installed........

|||

I didnt have to run as a separate step when I install the SQL Developer on XP SP2.

I do have XP SP2 on my PC and when I run the SQL 2005 Standard Edition, I didnt see the Server Management Studio.

So it is a separate step after a normal install?

Is it Performance Tool? Or a tool folder on the SQL 2005 STD Edition CD?

|||

there will be a tool folder may be you can insert the disk 2 and check it.....generally there will 2 folders in sql 2005 one is server and other is tool.........

|||

The default install ONLY installs the Server and network connections support.

To install SSMS, you need to put the media in again, and this time choose 'Client Tools' from the installation menu.

|||Management studio is not a performance tool, its just an replacement for Enterprise Manger

I do not have the option to create an Integration Service project in Business Management Studio

Hi,

I have installed the advanced toolkit for Microsoft Sql server 2005, with the SQL server Business Intelligence Development Studio but I don't have the option the create a Integration Service project. I only have the Report Server project option available.

Do I have to download something else to get it?

I do not have a SQL server instance installed on the machine I installed the toolkit on.

Thank you

What version of SQL Server do you have installed? You need Standard, Developer, or Enterprise.|||

Oh I see, I have the express edition.

I guess I'll get to play with that if we buy one of those editions some day

Thank you

|||Developer edition is $50, but cannot be used in a production environment.

I cant see my Procedure. Why? This is my first Stored Procedure.

Hello,

I created the "MyDb" database using Microsoft SQL 2005 Server Management Studio and I added the table "dbo.Surveys".

Then I right clicked on Store Procedures and created a new procedure.
When I close it I am asked to save it. I save it and gave the file a name.
However my stored procedure doesn't show in the Stored Procedures list.
I can only access it by loading the file (File > Open > File). Why?

When I open the File the Connect Window shows again.

I believe the procedure is created because I used CREATE.
When I execute it twice I got the message that there is already another procedure with that name so I change CREATE to ALTER.

Could you explain to me how to make my procedure visible in:
Databases/MyDb/Programmability/StoredProcedores

How to run it with dbo.Surveys table and see all the records that returns?

Thank You,
Miguel

My Stored Procedure code is:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE dbo.Surveys_GetSurveyBySurveyName
-- Procedure Parameters
@.SurveyName nvarchar
AS
BEGIN
-- Prevent extra result sets from interfering with SELECT statements
SET NOCOUNT ON;

-- Procedure statements
SELECT m.SurveyName
FROM dbo.application_Surveys
WHERE @.SurveyName = u.SurveyName

IF ( @.@.ROWCOUNT = 0 ) -- Survey Name not found
RETURN -1
RETURN 0

END
GO

USE MyDb

GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE dbo.Surveys_GetSurveyBySurveyName
-- Procedure Parameters
@.SurveyName nvarchar
AS
BEGIN
-- Prevent extra result sets from interfering with SELECT statements
SET NOCOUNT ON;

-- Procedure statements
SELECT m.SurveyName
FROM dbo.application_Surveys
WHERE @.SurveyName = u.SurveyName

IF ( @.@.ROWCOUNT = 0 ) -- Survey Name not found
RETURN -1
RETURN 0

END
GO

this one can create on sp on my machine.

Limno

|||

You must have created the stored proc in some other database.

Here's a script from SQLServerCentral.com that you can use to find any object: Compile the script in master database and exec it with the stored proc name.

/*
Purpose- Search object across database server.
Author-Vidyadhar P.
Email-vidya_pande@.yahoo.com
Date-6th-Feb-2006
Location- Pune,India
Input Parameters
@.object_name= Name of object to be searched part of object nameto be searched
@.ExactORLikeSearch= If no parameters are passed Sp will search for exact object names.
if 'L' is passes as parameter it will to like seach.
*/

create procedure dbo.sp_find_object -- 'product_master','L'
@.object_name varchar(100),
@.ExactORLikeSearch char(1)=E --E/L
as
begin
set nocount on
declare @.databases table (colid int identity ,dbname varchar(50))
create table ##object_db (dbName varchar(100), objectName varchar(100),objectType varchar(100))
insert into @.databases (dbname) select name from sysdatabases where dbid>4 and name not in ('pubs','northwind', 'holding_tank')
declare @.max_dbs int
select @.max_dbs=max(colid) from @.databases
declare @.current_db varchar(100)

declare @.Qstr nvarchar(2000)
declare @.Qstr1 nvarchar(2000)
set @.Qstr='insert into ##object_db select '
set @.Qstr1=''

declare @.i int
set @.i=1

while @.i<=@.max_dbs
begin
select @.current_db=dbname from @.databases wherecolid=@.i
--------------------------
if @.ExactORLikeSearch='E'

set @.Qstr1=@.Qstr+''''+@.current_db+''''+',name, case xtype when '+''''+'U'+'''' +' then ' +''''+'table'+''''+' when ' +''''+'P'+''''+' then '+''''+'procedure'+''''+' when '+''''+'F'+''''+' then '+''''+'function'+''''+' when '+''''+'V'+''''+' then '+''''+'view'+''''+ ' end as ObjectType
from '+@.current_db+'.dbo.sysobjects wherename='+''''+@.object_name+''''
--------------------------
if @.ExactORLikeSearch='L'

set @.Qstr1=@.Qstr+''''+@.current_db+''''+',name, case xtype when '+''''+'U'+'''' +' then ' +''''+'table'+''''+' when ' +''''+'P'+''''+' then '+''''+'procedure'+''''+' when '+''''+'F'+''''+' then '+''''+'function'+''''+' when '+''''+'V'+''''+' then '+''''+'view'+''''+ ' end as ObjectType
from '+@.current_db+'.dbo.sysobjects where namelike'+''''+'%'+@.object_name+'%'+'''' +'and xtype in ('+''''+'U'+''''+','+''''+'P'+''''+','+''''+'F'+','+''''+''''+'V'+''''+')'
--------------------------

exec sp_executesql @.Qstr1
set @.i=@.i+1
end

select * from ##object_db
drop table ##object_db

end

sql

i can't deploy a report from SQL Server Business Intellegience Development Studio

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/ReportServer.

ADDITIONAL INFORMATION:

The request failed with HTTP status 405: Method not allowed. (Microsoft.ReportingServices.Designer)

BUTTONS:

OK

I have installed:

* SQL Server 2005 Express Edition SP1

* SQL Management Studio Express

* SQL Server 2005 Express Edition with Advanced Services SP1

* SQL Server 2005 Express Edition Toolkit SP1

I'm trying to create a simple report, that display only a list of names. "Select * From Table"

Any ideas?

Hi,

switch the logging mode of SQL Server Reporting Services to Verbose and try it again, post the specific log snippets of the log according the error to the forum.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Hey, Jens

I uninstalled SQL Server Express and all its components, and reinstalled the SQL Express SP1 Edition, i'm no longer going to use the reporting services anymore, as long as i know that SQL Server Express can create reports and deploy it to, other computers. I'm ok, and Thanks for the reply to my Message.

Lloyd Arcales

i can't deploy a report from SQL Server Business Intellegience Development Studio

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/ReportServer.

ADDITIONAL INFORMATION:

The request failed with HTTP status 405: Method not allowed. (Microsoft.ReportingServices.Designer)

BUTTONS:

OK

I have installed:

* SQL Server 2005 Express Edition SP1

* SQL Management Studio Express

* SQL Server 2005 Express Edition with Advanced Services SP1

* SQL Server 2005 Express Edition Toolkit SP1

I'm trying to create a simple report, that display only a list of names. "Select * From Table"

Any ideas?

Hi,

switch the logging mode of SQL Server Reporting Services to Verbose and try it again, post the specific log snippets of the log according the error to the forum.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Hey, Jens

I uninstalled SQL Server Express and all its components, and reinstalled the SQL Express SP1 Edition, i'm no longer going to use the reporting services anymore, as long as i know that SQL Server Express can create reports and deploy it to, other computers. I'm ok, and Thanks for the reply to my Message.

Lloyd Arcales

I cant connect to sql server from a computer on my network

I am trying to log in to sql server on another desktop on my network.
When I open sql management studio I am able to find the server however
when I try to log in I am unable to connect. I have gone into the
configuration tool and enabled tcp/ip and named pipes remote
connections on the computer that is acting as the server but I still
get an error when I try to connect. How do I enable it so that I can
log onto the server on the other computer.npbaker1@.neo.rr.com wrote:
> I am trying to log in to sql server on another desktop on my network.
> When I open sql management studio I am able to find the server however
> when I try to log in I am unable to connect. I have gone into the
> configuration tool and enabled tcp/ip and named pipes remote
> connections on the computer that is acting as the server but I still
> get an error when I try to connect. How do I enable it so that I can
> log onto the server on the other computer.
>
Hi
What is the error message you get?
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator

I cant connect to sql server from a computer on my network

I am trying to log in to sql server on another desktop on my network.
When I open sql management studio I am able to find the server however
when I try to log in I am unable to connect. I have gone into the
configuration tool and enabled tcp/ip and named pipes remote
connections on the computer that is acting as the server but I still
get an error when I try to connect. How do I enable it so that I can
log onto the server on the other computer.npbaker1@.neo.rr.com wrote:
> I am trying to log in to sql server on another desktop on my network.
> When I open sql management studio I am able to find the server however
> when I try to log in I am unable to connect. I have gone into the
> configuration tool and enabled tcp/ip and named pipes remote
> connections on the computer that is acting as the server but I still
> get an error when I try to connect. How do I enable it so that I can
> log onto the server on the other computer.
>
Hi
What is the error message you get?
Regards
Steen Schlter Persson
Database Administrator / System Administrator|||Try the usual suspects:
1. Check whether the instance is running,
2. Try to connect to it locally,
3. Ping the other server from this machine to make sure you can reach it,
4. Try to connect to it using the IP address followed by the port number
after a comma
The messages or error messages from these tests should give you some clue.
Linchi
"npbaker1@.neo.rr.com" wrote:

> I am trying to log in to sql server on another desktop on my network.
> When I open sql management studio I am able to find the server however
> when I try to log in I am unable to connect. I have gone into the
> configuration tool and enabled tcp/ip and named pipes remote
> connections on the computer that is acting as the server but I still
> get an error when I try to connect. How do I enable it so that I can
> log onto the server on the other computer.
>

I can't connect to SQL server 2005 with Management studio express

Hi all,

my server is on internet and can be accessed by sqlb2.webcontrolcenter.com to my hoster.

I subscribe for SQL server 2005

I try to connect to sql server 2005 via Management studio express and visual web developper express without success. i got this error below with both:

Cannot connect to sqlb2.webcontrolcenter.com

a connectionmwas successfully established with the server, but then an error occured during the login process. (Provider: TCP provider, error: 0 -The specified network name is no longer available )

(Microsoft sql server, error 64)

thank's for your help

These errors indicate that the connection between the client and SQL Server was broken for some reason while SQL Server was writing data to the client. You mention that you are accessing the server across the internet, so part of the issue may be routing/firewall rules/devices between you and your provider...if you are able to get through to the server, you may not be able to get data back from the server or vice-versa.

Can you telnet to the TCP port that SQL Server is listening on? i.e. telnet to the IP and port combination you are trying to connect to?

Additionally, ensure your SQL Server is configured to allow remote connections.

This is typcially more of a transport-level issue than SQL Server error (in this case, TCP for example)...

|||

Hello Chad Boyd,

it was my firewall , i put it off and now my connection is working

Thank's for your response

I cant connect to my local sql server express db. Please help

Hello,

I need help to connect to my local sql express db in visual studio 2003 in vb.
It currently works with the production db information and I need to test a few things, So i'd like to point it to the local db.

It works this way:
Const CONN_STRING = "server=johndoe;user id=john;password=doe;database=johnd"
Dim conn As SqlConnection = New SqlConnection(Me.CONN_STRING)
conn.Open()

I want to point it to my local db and it doesn't connect.

Dim connectionString As String = "Data Source={myusername\SQLEXPRESS};Initial Catalog=johnd;Trusted_Connection=yes"
Dim conn As SqlConnection = New SqlConnection(connectionString)

Try
conn.Open()
Catch ex As Exception
Response.Write(ex.ToString())
End Try

and even that doesn't work.

When i go to my sql server 2005, it says
MYUSERNAME\SQLEXPRESS (SQL SERVER 9.0.3042 - theworknetwork\myusername

what am i doing wrong ?

Thanks.

You can try two things:

1) If you are an administrator on your local computer, then make sure that your user ID is in the Administrators group and then make that the Administrators group has access to the SQLEXPRESS instance. Change the user ID used by the SQL Server Management Tool with your local machine login, not your network login. If this doesn't work, replace it with the local machine Administrator account.

2) Instead of using Windows authorizations, use SQL Server authorizations. Create a new user in SQL Server specifically for your database. Make this user the dbo. Then use this user name with password in your ConnectionString.

At times, I have issues with Windows users because the passwords are different across the various computers. This has not been the case with SQL Server credentials, which I usually prefer.

Also, try using Integrated_Security in place of Trusted_Connection in the ConnectionString.

|||

Heres what I've tried. I went to that db (johnd), went to the security>users> and there is already a user called dbo

I tried doing Integrated_Security like you said and i got an error saying that is an invalid key. So here is what I have and it still doesn't work.

"Data Source={myusername\SQLEXPRESS};Initial Catalog=intranet;Trusted_Connection=yes;user id=dbo; password=dbo"

Any ideas?

|||

Can you please try with the following connection string if you are using NT Authentication:

Data Source={localmachine\SQLEXPRESS};Initial Catalog=intranet;Trusted_Connection=yes;

If you are using SQL Server User please try with the following connection string:

Data Source={localmachine\SQLEXPRESS};Initial Catalog=intranet;user id=<local sql server user>; password=<password>

Please make sure that you are changing the bold string with appropriate values.

Following URL provides you the steps to create the user:

http://www.microsoft.com/technet/prodtechnol/sql/2005/mgsqlexpwssmse.mspx

|||

I am in microsoft sql server managemen studio Object explorer (on left)
The very first item shows SDAVID\SQLEXPRESS

underneath that i have my database intranet

I then went to security > users [right click] > New User
Under Database User - New,
User Name: SDAVID
Login name
a new window came for Select Login and i found SDAVID [hit okay.]
* so now it shows User name: SDAVID
and login name shows SDAVID

under schemas owned by this user, I choose db_owner and db_securityadmin
under database membership i choose db_owner and db_securityadmin

Now under the code, here is what i have...

Const dbstring = "Data Source={SDAVID\SQLEXPRESS};Initial Catalog=intranet;user id=<sdavid>; password=<sdavid>"

Public Function testConnection()
Dim connectionString As String = "Data Source={SDAVID\SQLEXPRESS};Initial Catalog=intranet;user id=<sdavid>; password=<sdavid>"
Dim conn As SqlConnection = New SqlConnection(ConnectionString)
Dim cmd As SqlCommand = New SqlCommand("selec * from tblUsers", conn)
cmd.CommandType = CommandType.Text
Try
conn.Open()
Catch ex As Exception
Response.Write(ex.ToString())
Finally
conn.Close()
End Try

this generates the following error:
sqlException: Sql server does not exists or access denied.

thanks.

|||

Can you please use the following modified connection string:

Const dbstring = "Data Source=SDAVID\SQLEXPRESS;Initial Catalog=intranet;user id=sdavid; password=sdavid"

|||

Thank you. that did it! ..
Data Source=SDAVID\SQLEXPRESS;Initial Catalog=intranet;Trusted_Connection=yes;

|||

Hey Sri,

I tried it your way with specifying username and password and that did not work. Do you know why this could be ?

in Micrososft Sql Server Mangement Studio, i went to the db, Security > USers and created a user called sdavid with sdavid. I gave the user db_datareader and db_owner an under database roles membership gave it db_owner... i'd like to get the app working sql sever authhentication.

thanks.

I cannot logon to Http://localhost/reports$sqlexpress

Hello,
I am completely stuck. I have installed SQL server express server
advanced with reporting services. I can create some reports in Visual
studio 2005 IDE (from Acces database) but I cannot login to subj
address to do something from the web
I get the following response from my browser:
The server has encountered an error while loading an application
during the processing of your request. Please refer to the event log
for more detail information. Please contact the server administrator
for assistance
What does it mean? I use Windows XP Pro, SP2, using IIS 5.1. IIS is
functioning. I am logged as a user with Administrator rights. I can
browse web pages hosted on my IIS.
Searc on Google on this reveals a lot of hits which I have gone
through but no avail.
Also, how can I check that I have ASP.NET enabled on IIS'
Thanks,
AivarsOn Mar 15, 5:52 pm, "Aivars" <aiva...@.apollo.lv> wrote:
> Hello,
> I am completely stuck. I have installed SQL server express server
> advanced with reporting services. I can create some reports in Visual
> studio 2005 IDE (from Acces database) but I cannot login to subj
> address to do something from the web
> I get the following response from my browser:
> The server has encountered an error while loading an application
> during the processing of your request. Please refer to the event log
> for more detail information. Please contact the server administrator
> for assistance
> What does it mean? I use Windows XP Pro, SP2, using IIS 5.1. IIS is
> functioning. I am logged as a user with Administrator rights. I can
> browse web pages hosted on my IIS.
> Searc on Google on this reveals a lot of hits which I have gone
> through but no avail.
> Also, how can I check that I have ASP.NET enabled on IIS'
> Thanks,
> Aivars
You may need to reinstall SSRS Express w/Advanced Services. I had a
similar issue a few months back and that seemed to resolve it. To
check if ASP.NET is enabled for IIS, do the following:
- Right click 'My Computer' and select 'Manage.'
- Select Services and Applications -> Internet Information Services ->
Default Web Site
- Right-click either the Reports or ReportServer virtual directory and
select Properties.
- There should be a tab at the end called 'ASP.NET'. If you select it,
it will show you the ASP.NET version, etc.
- Also, the Virtual Directory tab is where you would set up connection
pooling (in case you needed to run different versions of Visual
Studio/ASP.NET and need to control which .NET framework is used for
what).
Hope this helps.
Regards,
Enrique Martinez
Sr. ASP.NET/SQL Server Developer|||Running the following statement in your Framework\v2.0.50727 directory
might help:
aspnet_regiis -i -enable
Regards,
Thomas
Aivars schrieb:
> Hello,
> I am completely stuck. I have installed SQL server express server
> <SNIP>
> Also, how can I check that I have ASP.NET enabled on IIS'|||Thanks who responded. I am at dead end - I have reinstalled 5(!!!)
times all SSRS and Toolkit and still I am getting the following error
when logging to reportserver:
The server has encountered an error while loading an application
during the processing of your request. Please refer to the event log
for more detail information. Please contact the server administrator
for assistance.
No clue whatsoever.
Any more ideas?
Aivars
Thomas H=FCtter wrote:
> Running the following statement in your Framework\v2.0.50727 directory
> might help:
> aspnet_regiis -i -enable
> Regards,
> Thomas
>
> Aivars schrieb:
> > Hello,
> > I am completely stuck. I have installed SQL server express server
> > <SNIP>
> > Also, how can I check that I have ASP.NET enabled on IIS'|||Well, what do your event logs say around the time the error happens?
Aivars schrieb:
> Thanks who responded. I am at dead end - I have reinstalled 5(!!!)
> times all SSRS and Toolkit and still I am getting the following error
> when logging to reportserver:
> The server has encountered an error while loading an application
> during the processing of your request. Please refer to the event log
> for more detail information. Please contact the server administrator
> for assistance.|||Thomas, thank you very much.
I reinstalled windows(!). Now i can at least get the to the home page
of reportserver (it looks like it) but it responds with an error:
The report server is not responding. Verify that the report server is
running and can be accessed from this computer. But it is a home page
of report server.
It looks like I am closer. What is that last thing which I am
suppposed to do?
I think that is something to do with windows xp security?
Thanks,
Aivars
Thomas H=FCtter wrote:
> Well, what do your event logs say around the time the error happens?
>
> Aivars schrieb:
> > Thanks who responded. I am at dead end - I have reinstalled 5(!!!)
> > times all SSRS and Toolkit and still I am getting the following error
> > when logging to reportserver:
> >
> > The server has encountered an error while loading an application
> > during the processing of your request. Please refer to the event log
> > for more detail information. Please contact the server administrator
> > for assistance.|||Finally I did get it to work. I had tu use rskeymgmt utility to delete
encrypted contend. And do not ask me why because i do not know myself
how i had something encrypted on server.
maybe when configuring the report server there is an option to encrypt
and i had used it by accident.
Anyway, thanks to all who responded. There is a plethora of
information in Books online and Google is your friend!
Aivars
Aivars wrote:
> Thomas, thank you very much.
> I reinstalled windows(!). Now i can at least get the to the home page
> of reportserver (it looks like it) but it responds with an error:
> The report server is not responding. Verify that the report server is
> running and can be accessed from this computer. But it is a home page
> of report server.
> It looks like I am closer. What is that last thing which I am
> suppposed to do?
> I think that is something to do with windows xp security?
> Thanks,
> Aivars
> Thomas H=FCtter wrote:
> > Well, what do your event logs say around the time the error happens?
> >
> >
> > Aivars schrieb:
> > > Thanks who responded. I am at dead end - I have reinstalled 5(!!!)
> > > times all SSRS and Toolkit and still I am getting the following error
> > > when logging to reportserver:
> > >
> > > The server has encountered an error while loading an application
> > > during the processing of your request. Please refer to the event log
> > > for more detail information. Please contact the server administrator
> > > for assistance.

I can no longer connect to my SQL Server Express 2005 from Manager Studio Express

Everything was working fine. I have been able to connect using windows authentication. Then, I went into the ODBC manager to add a data source and it failed to connect so I went back into the Server management studio to modify users. After doing this I now get an error when I try to conenct the management studio to the SQL server.

I wasn't modifying the login for my windows account that I normally use, I was modifying a different one, however I now get the message "An error has occured while establishing a connection to the SQL server. This kind of problem can ocure because the default behavior of the server does not support all connection methods" blah blah.

Does anyone know how I can attach to the server? Or, do I need to somehow remove the server and create a new one? How would I do that?

Thanks in advance for any input.

Hi,

did you disable remote connections by accident ? If so, see if this feature is enabled under the Serface Configuration. See more detaisl on the screencast on my site.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Hyperlink Action

When I run my report in Visual Studio and click on the hyperlink, it works
fine.
However, when I run my report via the browser after deploying it, the
hyperlinks doesn't work.
Please help!I am receiving an Internet Explorer error when clicking on the hyperlink. I
did not have this problem previously nor did I changed the report.rdl file
etc.
Line: 129
Char: 5
Error: 'event' is null or not an object
Code: 0
URL: http:://reportserv/reports/paages/report.asppx?ItemPath=%
2fDesigners_Council%2fReports%2fForm_Letter
"Terry" wrote:
> When I run my report in Visual Studio and click on the hyperlink, it works
> fine.
> However, when I run my report via the browser after deploying it, the
> hyperlinks doesn't work.
> Please help!