Again SQL Server 2008 problem

With the release of SQL Server 2008 I've tried to use it with SQL Assistant but I can't connect it.
I've tried also to connect with Sql Management Studio 2008 to an Sql Server 2005 database but still can't connect.
With SQL Server 2008 Beta 2 worked but with final version doesn't.
Any ideas ?
Sorin

Which version of SQL Assistant are you using?

3.5.30

3.5.30

I'm not sure what Microsoft changed/broke in the latest release. 3.5.30 was/is compatible with all previous SQL 2008 release candidates. So I guess a new compatibility update is needed again for supporting SQL 2008 in order to catch up with latest Microsoft changes.

By the way, the "final" release that you have mentioned was actually released to manufacturing on Aug. 6, which is less than a week ago and the on-line download is available only for a few days.. :)

I would expect that it is going to take several weeks before a compatibility patch become ready. On the other had, I don't know if there will be any new updates released for version 3. We are currently actively working on a new major version.

Hi
Here are some screenshots

If you have a beta (build) of this new release I'll be happy to test it.
I was testing all versions of this product and I want to try to make it better (especialy on 2008 and Vista).
Thank's

Sorin

Thanks for the info.

A beta version is not yet available at this time. We will post an announcement on this board as soon we reach that milestone.

We have tried the latest SSMS release 10.0.1600.22 that comes with the latest build of SQL 2008 and so far we are unable to reproduce this issue. Could you please explain again what is wrong? Can you connect to SQL 2008 using Notepad and SQL Assistant configured to use ADO.NET connection type with Notepad? Is there a problem with SQL Assistant silently intercepting and sharing connections in SSMS 2008? The screenshot shows something really weird in the Server name property, displayed as SQLQuery1. Is that a shared connection or something you entered manually?

I am having same problem with SQL 2008 Management Studio release.
My configuration:
OS Vista Ultimate SP1
SQL assistant 3.5.30

[/img]

Can you connect with Notepad?

Please don't consider the above question stupid. We need to figure out whether the problem is caused by SSMS not providing a valid connection pointer or by the connectivity itself.
Secondary, which connection type is currently selected in the settings? ADO.NET or ODBC?

Which exact version and build of SQL 2008 Management Studio are you running?

Yes I can,
I can connect with notepad and with SQL 2005 Management Studio
here is the SQL 2008 Management Studio information.
Current connection is ODBC.

Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
Microsoft Analysis Services Client Tools 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 7.0.6001.18000
Microsoft .NET Framework 2.0.50727.3053
Operating System 6.0.6001

Thanks. this info is helpful.

I figured out.
In Vista I have to run SQL Assistant as Administrator.
It works now.

or use this:
http://www.howtogeek.com/howto/windows-vista/always-start-an-application-in-administrator-mode-on-windows-vista/

Cool. Thank you for the update

Doesn't work for me even with Administrator
I have same configuration as lodmit.
Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
Microsoft Analysis Services Client Tools 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.6001.18000
Microsoft .NET Framework 2.0.50727.3053
Operating System 6.0.6001

In notepad it's working.