How to autenticate to local SQL Express server

I have VWD 2005 Express and SQL 2005 Express installed and I would like to convert my access database to SQL. I tried running the upsizing wizard in access and could not connect to the local sql express server. I downloaded and installed SQL Server Migration assistant for Access and same thing, I can not connect to the server. What credentials do I use, I've tried creating an account on the server using the server management utility and adding the user to every role available but still can not connect to the server.What's the error message? You can test connection of the DSN used in Upsizing Wizard in odbcad32.exe (ODBC Data Source Administrator) to see whether it will succeed.

How to add a image to the ReportVeiwer

Good day all

I have the vwd 2005 express and am playing around with the report veiwer.

How can i put the image on my report ( as a header) . I have draged the image control from the toolbox onto my Report.rdlc form , but it,s not the same as the image control in the toolbox for the "aspx" forms. I cannot right click and set a image URL.

There is a backgroundImage property but the wording is unfamilier to me eg, Source.. External , Value... MIMEType etc.

Can anyone help with getting the image into the report?

Thanks

Rob

Hi Rob,

The only way to add image in the report is by using the image control, and yes its different from the one for the aspx pages.

When you place a image control on the form an image wizard will be opened where you can choose whether you want the image to be embadded into the report itself/use a common image for a project/image stored in database/use an image hosted on net.

Just select the appropriate option and select the image. For more information check these links -

http://msdn2.microsoft.com/en-us/library/ms156388.aspx

http://msdn2.microsoft.com/en-us/library/ms156482.aspx

how to access sql server express from other computer on the netwrok

Hi experts

I use a sqlserver on a local computer. i want to access the sqlserver from other computers on the network using the VWD. When trying to connect to the database i get the error:

"An error has occured while establishing a connection to the server. When connecting 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 connection to SQL Server)"

I enabled the TCP/IP and the Named Pipes protocols on the server and still the same error.

Thanks

check windows firewall enbale or not..

if yes, then let sql 2005 port pass through

|||

I just found the sollution.

1. when accessing from other computers, the servers 'Guest' account is used, so this accoun should have the correct permissions (not recommended) or access using another privileged acount

2. enable remote connection in the "SQL Serve surface area Configuration" tool

Thanks for the attention anyway