I changed a report name, and get error "Execution 'fralkj45eeyh0te5opip4455' cannot be fo

hi

What I did is in VS2005, right click the report name, change it and then rebuilt it, deploy it. And then go to Report Manager, I can see the new one, but when i run it, it shows this error:

Execution 'fralkj45eeyh0te5opip4455' cannot be found

what does this mean, does anybody know how to fix it?
thanks.

It should be fine after changing the name.
I delete it from report manager, and re-build, delopy to the report server, then it works fine.

I cant find sql server on my computer

I installed sql server on my PC, and when I look at the Programs I do
find sql server, but when I click on that I get "configuration tools".
I don't see anything that says "enterprise manager" for instance. How
can I find it so I can make a shortcut to it?
ThanksIf you installed SQLServer2k (not the msde edition) you should find the
Managment SnapIn with the name SQL Server Enterprise Manager.msc
somewhere on your computer (YOu insallation computer). Otherwise you
can also define your own MMC with importing Snapins in any MMC console.

HTH; Jens Suessmeyer.|||On 4 Feb 2006 02:18:02 -0800, BLACKDOG157@.LYCOS.COM wrote:

>I installed sql server on my PC, and when I look at the Programs I do
>find sql server, but when I click on that I get "configuration tools".
>I don't see anything that says "enterprise manager" for instance. How
>can I find it so I can make a shortcut to it?
>Thanks

Hi Blackdog157,

In addition to Jens' answer:

- Are the client tools installed oon your workstation?
- If so, are they installed with default settings?

If both questions are answered with "yes", then you should find
Enterprise Manager (as well as Query Analyzer and all other tools) via:
Start / Programs / Microsoft SQL Server / Enterprise Manager

--
Hugo Kornelis, SQL Server MVP|||Hi

To add to the others... you may to look around the Control Panel/Add Remove
programs to see what is there. SQL 2005 has a report feature within this
that will give you more details.

For SQL 2005 executables look for SqlWb.exe on you Hard Drive and
SQLServerManager.msc, you could also try osql and/or sqlcmd (for SQL 2005)
from a command prompt.

John

<BLACKDOG157@.LYCOS.COM> wrote in message
news:1139048282.042362.258000@.z14g2000cwz.googlegr oups.com...
>I installed sql server on my PC, and when I look at the Programs I do
> find sql server, but when I click on that I get "configuration tools".
> I don't see anything that says "enterprise manager" for instance. How
> can I find it so I can make a shortcut to it?
> Thanks|||(BLACKDOG157@.LYCOS.COM) writes:
> I installed sql server on my PC, and when I look at the Programs I do
> find sql server, but when I click on that I get "configuration tools".
> I don't see anything that says "enterprise manager" for instance. How
> can I find it so I can make a shortcut to it?

It sounds as if you installed SQL Server Express 2005. The Express
download does not include any other qurey tool than SQLCMD, which is a
command line tool.

However, a stripped-down version of SQL Server Managerment Studio is
available as beta from
http://www.microsoft.com/downloads/...playLang=en&Src
CategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3d82afbd5 9
-57a4-455e-a2d6-1d4c98d40f6e%26DisplayLang%3den

--
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 cant delete a row

i cant delete a row on my table. when i click delete it say : "Insufficient key column information for updating or refreshing....." what can i do?The message smells like you might be using Microsoft Access to edit a table stored in Microsoft SQL, but that you don't have all of the defined key columns in the edit control. If that is correct:

1. Verify that there is a defined key
1a. Should be a PRIMARY KEY definition
1b. Could be a UNIQUE constraint
1c. Might be a UNIQUE INDEX
2. Identify all columns in all of the potential defined key(s) from step 1.
3. Ensure that all of the columns from at least one of the defined keys are present in your edit control.

-PatP|||thanks but i didnt use access. i copy and paste a row in my table. then i wanted to delete that row but i cant delete. all of my other rows can be cleaned but that row cant be delete.|||Nope, it isn't possible to "copy and paste a row in my table" because there isn't any GUI representation for a table. What you are doing (very possibly without realizing it) is copying and pasting within some application running on your machine, not actually on the table itself.

Since you haven't given us (the readers) many clues, but you have ruled out Microsoft Access, I'll make another guess... This time I'll guess Captain Peacock, in the Drawing Room... Oh wait, wrong game! ;)

Let's try this guess: Are you possibly using SQL Enterprise Manager, and Editing a table grid control? If so, please let me know and we can start to solve your problem... If not, I might try to guess again!

Just in case you didn't get the idea, I'm frustrated. You're asking me to help you solve a problem, but you haven't given me anything concrete to work from. I assume that you are using SQL Server, and that you haven't used it very much so you're handicapped in explaining your problem, and it appears that English isn't your native language which would further complicate things for you... I'm trying to help, but I need you to help me more so that I can help you!

If you can read English comfortably, please see this forum's FAQ for Brett Kaiser's excellent suggestions for How to Ask a Question to Get Quick and Correct Answers (http://www.dbforums.com/showthread.php?t=1212452#post4527530).

-PatP|||yes! you are right. im sorry. now i am using sql server 2000 enterprise manager. i create a table (same nortwind "order details"). remember i create an olap cube such as nwind
here is my fields:

accountno (varchar50)
medicineno(nvarchar15)
saleprice(float8)
quantity(float8)

i click return all rows and enter my records

1 101 $4 3
1 102 $3 2
2 102 $5 3
3 207 $2 1
....................
56 101 $4 2

and then i copy this row (2 102 $3 2) and paste it

........................
56 101 $4 2
2 102 $3 2

then i wanted to delete that row (2 102 $3 2)
but it cant be deleted. warning: "key column info insufficient or wrong. updating affects more rows" (i translated english. maybe it can be wrong)|||Have dealt with this in the past dealing with others issues.

You need to write a delete statment to accomplish this in query analyzer.

delete from table where accountno = 2

try inserting a new row as follows|||The problem stems from the fact that you do not have a unique primary key defined on your table. Thus, when you try to delete one record SQL Server cannot tell which record it is.
Add a primary key to your table. A surrogate key will do fine. But I also agree that you should not edit data from the Enterprise Manager GUI. Use Query Analyzer.|||thanks i will try

I can't add a user in "Security/Logins"

Good morning everyone,
I've a user listed in "Security/Logins".
If I right/click a database, Properties, "Permission" tab, I can't "Add" it
to database's "Users or roles": if I "Browse" for users, it isn't listed. How
can I add?Under Security - Logins, right-click the user and hit properties. (IN
SQL 2000)Go to the database access tab, select the db you want to grant
access to then give the rights below. By default, you only grant
public.
natasha wrote:
> Good morning everyone,
> I've a user listed in "Security/Logins".
> If I right/click a database, Properties, "Permission" tab, I can't "Add" it
> to database's "Users or roles": if I "Browse" for users, it isn't listed. How
> can I add?|||Yes, and in SQL 2005 "database access" tab has been substituted by "User
mapping" tab. But, owner of the database is dbo, and differently from other
DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
Is there any way to force a "take ownership" of the database?
"PSPDBA" ha scritto:
> Under Security - Logins, right-click the user and hit properties. (IN
> SQL 2000)Go to the database access tab, select the db you want to grant
> access to then give the rights below. By default, you only grant
> public.
> natasha wrote:
> > Good morning everyone,
> > I've a user listed in "Security/Logins".
> > If I right/click a database, Properties, "Permission" tab, I can't "Add" it
> > to database's "Users or roles": if I "Browse" for users, it isn't listed. How
> > can I add?
>|||Have you tried using the following stored procedure on the database where you
wnat the user to have access to:
EXEC sp_adduser 'loginname', 'username'
See if that works or give any error?
Lucas
"natasha" wrote:
> Yes, and in SQL 2005 "database access" tab has been substituted by "User
> mapping" tab. But, owner of the database is dbo, and differently from other
> DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
> Is there any way to force a "take ownership" of the database?
>
> "PSPDBA" ha scritto:
> > Under Security - Logins, right-click the user and hit properties. (IN
> > SQL 2000)Go to the database access tab, select the db you want to grant
> > access to then give the rights below. By default, you only grant
> > public.
> >
> > natasha wrote:
> > > Good morning everyone,
> > > I've a user listed in "Security/Logins".
> > > If I right/click a database, Properties, "Permission" tab, I can't "Add" it
> > > to database's "Users or roles": if I "Browse" for users, it isn't listed. How
> > > can I add?
> >
> >|||I tried to, and I've quite a curious error:
Msg 15063, Level 16, State 1, Line 1
The login already has an account under a different user name.
"Lucas Kartawidjaja" ha scritto:
> Have you tried using the following stored procedure on the database where you
> wnat the user to have access to:
> EXEC sp_adduser 'loginname', 'username'
> See if that works or give any error?
> Lucas
> "natasha" wrote:
> > Yes, and in SQL 2005 "database access" tab has been substituted by "User
> > mapping" tab. But, owner of the database is dbo, and differently from other
> > DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
> > Is there any way to force a "take ownership" of the database?
> >
> >
> >
> > "PSPDBA" ha scritto:
> >
> > > Under Security - Logins, right-click the user and hit properties. (IN
> > > SQL 2000)Go to the database access tab, select the db you want to grant
> > > access to then give the rights below. By default, you only grant
> > > public.
> > >
> > > natasha wrote:
> > > > Good morning everyone,
> > > > I've a user listed in "Security/Logins".
> > > > If I right/click a database, Properties, "Permission" tab, I can't "Add" it
> > > > to database's "Users or roles": if I "Browse" for users, it isn't listed. How
> > > > can I add?
> > >
> > >|||> Is there any way to force a "take ownership" of the database?
sp_changedbowner
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"natasha" <natasha@.discussions.microsoft.com> wrote in message
news:FBFC25FE-C6C8-4B8E-A769-419169EF1DDB@.microsoft.com...
> Yes, and in SQL 2005 "database access" tab has been substituted by "User
> mapping" tab. But, owner of the database is dbo, and differently from other
> DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
> Is there any way to force a "take ownership" of the database?
>
> "PSPDBA" ha scritto:
>> Under Security - Logins, right-click the user and hit properties. (IN
>> SQL 2000)Go to the database access tab, select the db you want to grant
>> access to then give the rights below. By default, you only grant
>> public.
>> natasha wrote:
>> > Good morning everyone,
>> > I've a user listed in "Security/Logins".
>> > If I right/click a database, Properties, "Permission" tab, I can't "Add" it
>> > to database's "Users or roles": if I "Browse" for users, it isn't listed. How
>> > can I add?
>>|||Hmm... interesting.
I think you might want to try to run the following script on the database
that the user need to access:
EXEC sp_dropuser 'username'
GO
and then run the:
EXEC sp_adduser 'loginname', 'username'
GO
see if that works.
Lucas
"natasha" wrote:
> I tried to, and I've quite a curious error:
> Msg 15063, Level 16, State 1, Line 1
> The login already has an account under a different user name.
>
>
>
> "Lucas Kartawidjaja" ha scritto:
> > Have you tried using the following stored procedure on the database where you
> > wnat the user to have access to:
> > EXEC sp_adduser 'loginname', 'username'
> >
> > See if that works or give any error?
> >
> > Lucas
> >
> > "natasha" wrote:
> >
> > > Yes, and in SQL 2005 "database access" tab has been substituted by "User
> > > mapping" tab. But, owner of the database is dbo, and differently from other
> > > DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
> > > Is there any way to force a "take ownership" of the database?
> > >
> > >
> > >
> > > "PSPDBA" ha scritto:
> > >
> > > > Under Security - Logins, right-click the user and hit properties. (IN
> > > > SQL 2000)Go to the database access tab, select the db you want to grant
> > > > access to then give the rights below. By default, you only grant
> > > > public.
> > > >
> > > > natasha wrote:
> > > > > Good morning everyone,
> > > > > I've a user listed in "Security/Logins".
> > > > > If I right/click a database, Properties, "Permission" tab, I can't "Add" it
> > > > > to database's "Users or roles": if I "Browse" for users, it isn't listed. How
> > > > > can I add?
> > > >
> > > >

I cannot create a brand new MDF (sql server database) with Visual Basic 2005

Hi everybody:

I go to Server Explorer, right click on Data Connection, input the server name (that is, my own computer), give a new name to the database to create, and then inevitably get the error window saying:

An error occurred while establishing a connection to the server. When connectiong to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL server does not allow remote connections. (Provider: Named Pipes Provider, error 40, could not open a conection to SQL Server)

So, how to open a connection to SQL server 2005? I looked in the msdn but found absolutely nothing.

Please help

Paolo

There is a great blog post that discusses common causes of connection errors and the errors that you get when that problem exists. This particular error suggests that SQL Express is not running. Launch SQL Server Configuration Manager and verify that the server is running.

Mike

I cannot create a brand new MDF (sql server database) with Visual Basic 2005

Hi everybody:

I go to Server Explorer, right click on Data Connection, input the server name (that is, my own computer), give a new name to the database to create, and then inevitably get the error window saying:

An error occurred while establishing a connection to the server. When connectiong to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL server does not allow remote connections. (Provider: Named Pipes Provider, error 40, could not open a conection to SQL Server)

So, how to open a connection to SQL server 2005? I looked in the msdn but found absolutely nothing.

Please help

Paolo

There is a great blog post that discusses common causes of connection errors and the errors that you get when that problem exists. This particular error suggests that SQL Express is not running. Launch SQL Server Configuration Manager and verify that the server is running.

Mike

Hyperlink to send an Email

Hello,
I am looking for a way for users to click on a textbox and send an Email. I
got that to work if I set up 'On action' URL to
'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
If a user clicks next to A then Email should go to A@.myemail.com and if they
click next to B email should go to B@.myemail.com so on and so forth. I have A
and B here is value in my field MYFIELD. I tried using
mailto:Fields!MYFIELD.value that won't work.
Any ideas will be appreciated.
Thanks.Hi,
You can use the following expresion in the 'Jump to URL':
="mailto:" & Fields!MYFIELD.value
Use this with the equal sign and spaces. You can add
& "@.mycompany.com" if your field doesn't have the domain included
Jan Pieter Posthuma
"amitj" wrote:
> Hello,
> I am looking for a way for users to click on a textbox and send an Email. I
> got that to work if I set up 'On action' URL to
> 'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
> If a user clicks next to A then Email should go to A@.myemail.com and if they
> click next to B email should go to B@.myemail.com so on and so forth. I have A
> and B here is value in my field MYFIELD. I tried using
> mailto:Fields!MYFIELD.value that won't work.
> Any ideas will be appreciated.
> Thanks.|||Thanks Jan. But that didn't work. It's not recongnising that URL. When I used
mailto:Fields!MYFIELD.value without = sign it recognised that as URL but
didn't add the field name.
"Jan Pieter Posthuma" wrote:
> Hi,
> You can use the following expresion in the 'Jump to URL':
> ="mailto:" & Fields!MYFIELD.value
> Use this with the equal sign and spaces. You can add
> & "@.mycompany.com" if your field doesn't have the domain included
> Jan Pieter Posthuma
>
> "amitj" wrote:
> > Hello,
> >
> > I am looking for a way for users to click on a textbox and send an Email. I
> > got that to work if I set up 'On action' URL to
> > 'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
> > If a user clicks next to A then Email should go to A@.myemail.com and if they
> > click next to B email should go to B@.myemail.com so on and so forth. I have A
> > and B here is value in my field MYFIELD. I tried using
> > mailto:Fields!MYFIELD.value that won't work.
> >
> > Any ideas will be appreciated.
> >
> > Thanks.|||Hi,
You have to add also the qoutes (") and & symbols. You have to use the equal
(=) to let RS to calculate the field. The next part is a string "mailto:"
including the quotes. Then you concatenate by using the &-sign to the value
part: Fields!MYFIELD.value.
Totally will be: <code>="mailto:" & Fields!MYFIELD.value</code>
That will work.
Jan Pieter Posthuma
"amitj" wrote:
> Thanks Jan. But that didn't work. It's not recongnising that URL. When I used
> mailto:Fields!MYFIELD.value without = sign it recognised that as URL but
> didn't add the field name.
> "Jan Pieter Posthuma" wrote:
> > Hi,
> >
> > You can use the following expresion in the 'Jump to URL':
> > ="mailto:" & Fields!MYFIELD.value
> >
> > Use this with the equal sign and spaces. You can add
> > & "@.mycompany.com" if your field doesn't have the domain included
> >
> > Jan Pieter Posthuma
> >
> >
> > "amitj" wrote:
> >
> > > Hello,
> > >
> > > I am looking for a way for users to click on a textbox and send an Email. I
> > > got that to work if I set up 'On action' URL to
> > > 'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
> > > If a user clicks next to A then Email should go to A@.myemail.com and if they
> > > click next to B email should go to B@.myemail.com so on and so forth. I have A
> > > and B here is value in my field MYFIELD. I tried using
> > > mailto:Fields!MYFIELD.value that won't work.
> > >
> > > Any ideas will be appreciated.
> > >
> > > Thanks.

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!